I have a list of employees, Col A = Surname, Col B = Christian name, and Col
C = Employee number. On another sheet i have the same names but in a
different order (actually departments), to which i need to add the correct
employee number. VLOOKUP works but returns the first match only. When i
have two identical surnames, how do i then check the Christian names, to get
the correct employee number?
example:
A B C
Jones Jane 123
Jones Jeff 124

--
Big dog is always right - The fugitive