It's not a vlookup job, look here
http://www.cpearson.com/excel/Duplicates.aspx
--
Regards,
Peo Sjoblom
"Maureen" wrote in message
...
I know most of the posts here are for advanced users... but, please help!
I have a column of data in one spreadsheet (column A) in a workbook and
another column of data (also column A) in another spreadsheet in the same
workbook. I want to confirm that all of the data in the first spreadsheet
is
in the second, and identity those that are not.
I know this is a very very basic VLOOKUP statement, but I am lost.
thanks for anyones help,