Match telephone number with name

Hello.


I need help with this.

In one sheet there is name, work place and some categories. In other sheet there is name and phone number. I need to comibne name in first sheet with telefon number.


Like this.

Sheet1

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

Sheet2

A B
Name phone
John Smit 360256
.
.

There is over 2000 names in each sheet.

Basicly I need to put phone number in sheet one. Is there any way to do it with some formula?
Please notice that some names have no matching data in other sheet, so i was unable to compare data if i put it in alphabeticly order.

So i need to compare data (names), and then copy phone number in sheet1 colum F.

Thanks in advance.

(sorry on my english)

I was not able to insert table...

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

Exactly, excel doesn't know. So if there are no other information in Sheet2, combining the different information correctly will be hard if not Vlatkok wants to do a manually review of all the dublicated names?