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

Japser

Something like...

IF(A1=B1,"Match","")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
www.nickhodge.co.uk


"Jaz" <(E-Mail Removed)> wrote in message
news:uJr%(E-Mail Removed)...
>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.

Jaz wrote:
>
> 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

--

Dave Peterson