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.