Compare Columns in Different Spreadsheets

[jevers]

I have two different spreadsheets, and each has a column with the same information. I would like to link the two to allow for data comparison, so the spreadsheets will tell me if there are duplicates and/or missing data (for example, data on one spreadsheet but not on the other).

 

[inbp]

hi Jevers,


I think vlookup is best.


if you share your book it will help to find better solution.