VLOOKUP? Comparing multiple values in a column.

[t2true]

I have two lists of employee names - one with names and phone numbers; the other with names and locations.
The names in each list should match, but not necessarily. Some may have middle name or initial, or may have a hyphenated name.


I want to use the "locations" list to search the "numbers" list to add the phone number to the employee. I know I can do this with vlookup. However, there are several surnames that are duplicated:

Allen	Gabriel
Allen	Maria Fe
Allen	Matt
Alleyne	Josetta
Alva	Christian
Alvarado	Harold
Anderson	Jordan
Anderson	Richard
Anderson	Tura
Baker	Brian
Baker	Sally

<tbody>
</tbody>

How can I pull the correct number for an employee in this scenario? Can vlookup compare two columns in the same row and return a result?


Thanks

 

[VBE313]

Sounds like you need to use INDEX and MATCH. There is a lot of help on google.