| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking up Telephone Numbers
Good Day
I have not found anything in the discussion group relating to my query so please point me in the right direction if there is. I have a sheet with 1100 retail stores. Details include branch numbers, addresses, telephone numbers etc. Branch numbers are in Column A and phone numbers are in Column H. I am trying to find a solution to finding store telephone numbers without using Vlookup, Find etc. Can a Form possibly be created where I can enter the store number and only the Telephone number is found and displayed?? Regards Peter |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Looking up Telephone Numbers
It's still easiest with a formula ..
Assuming your source data as posted is in Sheet1 Then in Sheet2, you could have B2 for the input of the branch#, and drop this in C2: =IF(B2="","",INDEX(Sheet1!H:H,MATCH(B2,Sheet1!A:A, 0))) to return the tel# Dress up Sheet2 nicely to taste and hide away Sheet1 .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Peterp" wrote: Good Day I have not found anything in the discussion group relating to my query so please point me in the right direction if there is. I have a sheet with 1100 retail stores. Details include branch numbers, addresses, telephone numbers etc. Branch numbers are in Column A and phone numbers are in Column H. I am trying to find a solution to finding store telephone numbers without using Vlookup, Find etc. Can a Form possibly be created where I can enter the store number and only the Telephone number is found and displayed?? Regards Peter |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Looking up Telephone Numbers
Excellent - thanks Max - grief it's easy when you know how!
"Max" wrote: It's still easiest with a formula .. Assuming your source data as posted is in Sheet1 Then in Sheet2, you could have B2 for the input of the branch#, and drop this in C2: =IF(B2="","",INDEX(Sheet1!H:H,MATCH(B2,Sheet1!A:A, 0))) to return the tel# Dress up Sheet2 nicely to taste and hide away Sheet1 .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Peterp" wrote: Good Day I have not found anything in the discussion group relating to my query so please point me in the right direction if there is. I have a sheet with 1100 retail stores. Details include branch numbers, addresses, telephone numbers etc. Branch numbers are in Column A and phone numbers are in Column H. I am trying to find a solution to finding store telephone numbers without using Vlookup, Find etc. Can a Form possibly be created where I can enter the store number and only the Telephone number is found and displayed?? Regards Peter |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Looking up Telephone Numbers
Welcome, Peterp.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Peterp" wrote in message ... Excellent - thanks Max - grief it's easy when you know how! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I format telephone numbers? | Excel Worksheet Functions | |||
| Reformat column of telephone numbers | Excel Discussion (Misc queries) | |||
| how do i format telephone numbers | Excel Discussion (Misc queries) | |||
| how to enter telephone numbers in Excel sheet | Excel Discussion (Misc queries) | |||
| In Excel, I want to have all telephone numbers display in the sam. | Excel Worksheet Functions | |||
Linear Mode
