View Single Post
  #1   Report Post  
Lea
 
Posts: n/a
Default How can I match numbers from two columns?

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!