Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare two lists for matches
I would like to compare Sheet A (2005) with Sheet B (2007) I would like Sheet
A to reference Sheet B and look for a match for Consultant ID, if it finds Consultant ID than to compare Tax ID and tell me if they match or not. I need to know if it finds a match for consultant ID (Yes/No) and then if the Tax ID matches (Yes/No). What type of match or lookup formula can I use? Sheet A (2005) A B C 1 Consultant ID Tax ID Tax ID Updated? 2 1234 456 No 3 1235 654 Yes 4 1236 659 Not Found Sheet B (2007) A B 1 Consultant ID Tax ID 2 1234 456 3 1235 657 4 1289 637 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare lists and highlight matches | Excel Discussion (Misc queries) | |||
Compare lists and highlight matches | Excel Discussion (Misc queries) | |||
I need to compare to columns and indicate the matches in another | New Users to Excel | |||
An Algorithm that matches two lists | Excel Programming | |||
An Algorithm that matches two lists | Excel Programming |