Merrie419 said:

Thanks for the speedy response - I am trying your suggestions, My data in column A is sorted in Ascending order and I am pasting the formula in column D - I am getting blanks in all of those cells - Not sure why this is happening - the formulas aren't working for me - Any Suggestions?

Just in case my description was not clear here is how my data is structured

Column A Column B Column C D

Master Employee List Master Employee ID List Partial Employee List

John Doe 12345 John Doe

Jane Doe 12346 B Hill

A Hill 13579 A Smith

B Hill 17981

C Hill 12246

A Smith 14499

If A:B is sorted on A in ascending order......

D2, copied down:

=IF(LOOKUP(C2,$A$2:$A$7)=C2,LOOKUP(C2,$A$2:$B$7),"")

If A:B is not sorted on A in ascending order...

F2, copied down:

=IF(ISNUMBER(MATCH(C2,$A$2:$A$7,0)),VLOOKUP(C2,$A$2:$B$7,2,0),"")