How can I change a list of phone numbers into peoples names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
John said:
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.
Click to expand...

Hi John,

you can use the VLOOKUP function.

Check the online help and try to use the function. If you need any more
help, we are here...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
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
 
Back
Top