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

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

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

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!