Compare 2 columns

  • Thread starter Thread starter Jaz
  • Start date Start date
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
 
Put this in C1:

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

And drag down as far as column A is used.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for comparing columns and highlighting matching/differences 14
lookup and return column number 2
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
Can't Explain N/A in Vlookup 2
Figuring out a lengthy formula. Probably quite simple... 3
COUNTIF + ADDRESS Issue 1
Formatting and modelling 2
VLOOKUP formula? 12

Back
Top