Give this a try. In column B of Sheet 1 enter:

=IF(ISNA(VLOOKUP(A1,'Sheet 2'!$A$1:$A$100,1,FALSE)),"Missing","OK")

Copy down Column B for each value in column A. I just assumed your data was
in cells A1 thru A100. Change this range to meet your needs. Also, change
Sheet 2 to match the actual name of your second sheet.

HTH,
Elkar


"Maureen" wrote:

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,