Quote from Ger Plante;509877I'm not sure why you feel that the first method is the ideal. To me using a unique key identified is ideal, because then you can just a simple lookup formula -
In Aggregated Database sheet, cell C2:
=VLOOKUP($I2,'Original Database'!$H$1:$K$10000,2,FALSE)
Drag / copy this formula down for each line in your in aggregated database.
Adjust the $H$1:K10000 in the formula as this points to original database and I'm sure your original database might have more than 10000 rows. It can be made dynamic if you wish.
Unique numbers that arent found will return #N/A filter them out afterwards (you already have filter in place anyway).Regards,
Ger
Cheers Ger, I'll give that a go
The reason why using AccNo is not perfect is that I have manually merged some citations so that say if there were a pair of duplicates, one had all accurate info but no abstract, and the other had an abstract, and i copied the abstract from the second one into the first. Then if I use the AccNo of the first citation, it will find the merged citation in the aggregated database and replace that one's abstract with blank (as it was originally).
Would there be a way to make it ignore the citation in the original database if the abstract field was blank?
EDIT: I've tried it out now, it worked perfectly and I manually replaced the leftover abstracts which were not found and I think it's all done! Thankyou very much!