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

[John]

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.

 

[Franz Verga]

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.

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

 

[Muhammed Rafeek M]

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