Put this in C1
=IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),"Not in Col B","")
and copy down till the end of your data...

It will put "Not in Col B" in those rows where value in cell in Col A is not
found in Col B.

"IBE" wrote:

I have a worksheet that I'm trying to find the data from Column A that's not
in Column B. i have almost 4000 records and it's a pain to go through each
row. help please.