Compare columns in 2 sheets

[patty123467]

How can I figure out what is in column A of sheet 2 that doesn't exist in column A of sheet 1.

 

[Trebor76]

Hi patty1234567,

Put this formula in a blank cell...

=VLOOKUP(Sheet2!A1,Sheet1!A:A,1,FALSE)

...and copy it down the number of rows that there are in column A of Sheet2. Any entries not in column A of Sheet1 will return a #N/A.

Regards,

Robert