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