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.

Check your other post for suggestions.

Are you having trouble with your newsreader, and not seeing the numerous
posts that you're creating, or the answers to them?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Chris (new user)" wrote in message
...
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.