Looking up Telephone Numbers

P

Peterp

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
 
M

Max

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 ..
 
Top