compare data in two lists to find matching entries
 

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.

=IF(COUNTIF($A$1:$A$3,B1)0,"Match found","No match found")

A1:A3 contain your first list.
B1:B3 contain your second list.
C1:C3 use the formula above. Copy it into C1. then fill it down.

"Chris(new user)" wrote:

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.