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

C

Chris(new user)

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.
 
R

RagDyeR

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 !
--------------------------------------------------------------------

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.
 

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
compare data in two lists to find matching entries 1
Remove Data which is not match with other column 1
Word macro that can call cells out of Excel for a find and replace 0
Index and Match 5
List of Id's in one Colum list of names in another. More Id's on s 1
in excel where it says a b c d on top how to shrink that 1
Sumif a date time colum and information 6

Top