compare data in two lists to find matching entries

C

Chris(new user)

I have a spreadsheet with two colums. Each colum contains an identification
reference e.g.
Colum A Colum B
abc123456 nmg4568987
ahsj45236 abc123456
ikl7856489 jkh7854566589
I want excel to check if the items in colums b are also in colum a and
insert either "Match found" or "No match found" in colum c. For example
abc123456 nmg4568987 No match found
ahsj45236 abc123456 Match found
ikl7856489 jkh7854566589 No match found
Please help. I've tried everything I could think of. Nothing seems to work.
 
A

AlfD

Hi!

Put this in C1 (assuming your list starts at A1 and B1):

=countif(A1:A2000,B1)
This will tell you how many times B1 appears in the range A1:A2000.

Need I say more? If so, come back.

Alf
 

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

Check data on colum A and find match on colum b 3
Look up data in colum a and find match in colum b 1
Combining information from two excel list 3
Remove Data which is not match with other column 1
Index and Match 5
How do I compare the stored data in micro 3
compare two columns and find the matched id 1
Looking and matching vaules to return another vaule 0

Top