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,