Thread: How can I change a list of phone numbers into peoples names
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
  
Posts: 179
Default How can I change a list of phone numbers into peoples names
Use Vlookup function:
Ex:
A B
Phone No Name
9845898187 ABC
9847488983 DCE
9898789856 KCD

D E
9847488983 =VLOOKUP(D2,$A$1:$B$28,2,0)

Pls do rate


"John" wrote:

I have a large list of phone number from my phone bill which I have copied
into Excel and I would like to somehow lookup the number in my phone book
which is also in Excel and show the persons name from the phone number.
Reply With QuoteReply With Quote