Look up data in colum a and find match in colum b
 

I have a sheet containing two lists of ID's e.g.
Colum A Colum B
abc123456 hjt456897
hjk8966536 jk456654558
hgg009664 jjk5566377
The colums contain 2000 entries. I want to check if the items in colum b
match the items in colum a. I would like excel to do this check and in colum
c show Match or No Match e.g.
abc123456 hjt456897 Match
hjk8966536 hgg009664 Match
hgg009664 jjk5566377 No match
hjt456897 jjk hjkjhd No match
Please help.

Chris
In Colum C type =EXACT(A1,B1) it will show True or False rather than Match
and No Match.
Jess



"Chris(new user)" wrote:

I have a sheet containing two lists of ID's e.g.
Colum A Colum B
abc123456 hjt456897
hjk8966536 jk456654558
hgg009664 jjk5566377
The colums contain 2000 entries. I want to check if the items in colum b
match the items in colum a. I would like excel to do this check and in colum
c show Match or No Match e.g.
abc123456 hjt456897 Match
hjk8966536 hgg009664 Match
hgg009664 jjk5566377 No match
hjt456897 jjk hjkjhd No match
Please help.