| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I change a list of phone numbers into peoples names
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can I change a list of phone numbers into peoples names
"John" ha scritto nel messaggio
... 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting groups of exact numbers in a huge list (column) | Excel Discussion (Misc queries) | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| Macro to change validation list and print | Excel Discussion (Misc queries) | |||
| change format for phone numbers automatically | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Linear Mode
