Compare 2 columns

J

Jaz

I have 2 columns that I want to compare. Want column 1 to see if there is a
matching number in column 2. Then, I want the third column to say 'Match'
so I can identify which ones match.

How would I do this?

Thanks,
Jasper
 
D

Dave Peterson

Put this in C1:

=if(isnumber(match(a1,b:b,0)),"Match","No Match")

And drag down as far as column A is used.
 
Top