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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
Match name colums and paste corresponding values 1
comparing colum data and exporting 3
Combining information from two excel list 3
in excel where it says a b c d on top how to shrink that 1
How do I compare the stored data in micro 3
Sorting data to match existing data 4

Back
Top