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:

[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"]Allen[/TD]
[TD="width: 64"]Gabriel[/TD]
[/TR]
[TR]
[TD]Allen[/TD]
[TD]Maria Fe[/TD]
[/TR]
[TR]
[TD]Allen[/TD]
[TD]Matt[/TD]
[/TR]
[TR]
[TD]Alleyne[/TD]
[TD]Josetta[/TD]
[/TR]
[TR]
[TD]Alva[/TD]
[TD]Christian[/TD]
[/TR]
[TR]
[TD]Alvarado[/TD]
[TD]Harold[/TD]
[/TR]
[TR]
[TD]Anderson[/TD]
[TD]Jordan[/TD]
[/TR]
[TR]
[TD]Anderson[/TD]
[TD]Richard[/TD]
[/TR]
[TR]
[TD]Anderson[/TD]
[TD]Tura[/TD]
[/TR]
[TR]
[TD]Baker[/TD]
[TD]Brian[/TD]
[/TR]
[TR]
[TD]Baker[/TD]
[TD]Sally[/TD]
[/TR]
</tbody>[/TABLE]


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.