One way assuming the list you want to check is in column B starting in
row 1, in C1 enter the formula:
=IF(ISNA(VLOOKUP(B1,A:A,1,0)),"It's not in Column A","Yes, it's in
column A")
and copy down.

Hope this helps
Rowan

Lea wrote:
I have two columns with numbers. Some numbers are in both columns, some not.
What I need to get is some formula that can compare both columns and tell me
wich numbers are already in column 1 and what numbers are not.
Something like this:

234 222 It's not in column A
444 300 Yes, it's in column A
300 150 It's not in column A

I'll appreciate any help!