[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Excel replace telephone number with Name

Hi,

I have an excel spreadsheet (a) with thousands or records.  One of the data items is a telephone number.  I have another sheet (b) with a list of telephone numbers and names, I would like to go through each record in (a) and replace the telephone number with the name in (b) which correspondes to the telephone number.  Any help appreciated.
0
Alansherwen
Asked:
Alansherwen
  • 2
1 Solution
 
chwong67Commented:
Use VlookUp,
For example,
Sheet1 ColumnA= Telephone#, Column B=Name;
=IFERROR(VLOOKUP(A2,Sheet1!A:B,2,FALSE),"")
0
 
asiduCommented:
Please have a look at the attached example done in office 2007.
For accurate results the telephone number in sheet A must be sorted
from small to large.

vlookup.xls
0
 
chwong67Commented:
From the above example, if your telephone number is '51555555', then name found is 'Goh Sun Lohke' which is incorrect.
The formula should have EXACT match,
In this example,
=VLOOKUP(A2,SheetA!$A:$B,2,FALSE)
If add error (N/A) to be blank,
=IFERROR(VLOOKUP(A2,SheetA!$A:$B,2,FALSE),"")

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now