Match telephone number with name

Hi,

Assuming your data in Sheet1 start in A2 then use this formula in F2:

=IFERROR(VLOOKUP(A2;Sheet2!A2:A2000;2;0);"")

depending of your regional setting change ";" with "," in that formula.

IFERROR is for excel version >=2007

Using vlookup will only work as long as there are no dublicated names?

Originally Posted by kimrh

Using vlookup will only work as long as there are no dublicated names?

No, it works with duplicates but will display only the first item found in that range.

Thats what I meant, if you have two persons named John Smith, you will get the same phone number on both individuals.

Sheet1

A B C D E
name titule workplace Limit Cat.
John Smit Manager London, HO 100 1
John Smit Senior Manchester, HO200 2

Sheet2

A B
Name phone
John Smit 360256
John Smit 504030

Result:
A B C D E F
name titule workplace Limit Cat.
John Smit Manager London, HO 100 1 360256
John Smit Senior Manchester,HO200 2 360256