Hello Lea
=IF(NOT(ISERROR(MATCH(B1,$A$1:$A$8,0))),"Yes it's in column A","it's not in
column A")
Please amend accordingly (only values in A1 through A8 tested here)

HTH
Cordially
Pascal

"Lea" <Lea @discussions.microsoft.com a écrit dans le message de news:
...
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!