Drop down menu / list

[HH]

In C16 I would like a drop down menu or list where the user could select
from - Home Phone, Work Phone, Cell Phone etc and have the ability to type a
better explanation in this list if needed.
In E16 the user would type in the "Home" phone number . He could then go
back to C16, select "Cell" and type that number in E16.
Later the drop down box would allow the user to select "Work Phone" and the
proper number display in E16.

Is this possible in excel and how can it be done?

 

[Gord Dibben]

VLOOKUP formula and a lookup table?

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for inputting
the data.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

 

[HH]

I'm still very new to programming in excel. VLOOKUP is great but I have not
been able to use it in my case.
I can use Data Validation to create a drop down for Home Phone:, Cell
Phone:, Work Phone:, etc but, in the column to the right, I want to type in
the acutal Home Phone, Cell Phone, etc.
Later, when using this information, I would like to be able to select "Home
Phone" in the drop down box and have the number I typed in to be displayed.
From what little I have learned about VLOOKUP, I have not seen this used. I
guessing the different phone numbers will need to be saved elsewhere in the
worksheet when I type them in ..
Can it be? How?

 

[HH]

Anybody else got an idea?
Thanks

I'm still very new to programming in excel. VLOOKUP is great but I have
not been able to use it in my case.
I can use Data Validation to create a drop down for Home Phone:, Cell
Phone:, Work Phone:, etc but, in the column to the right, I want to type
in the acutal Home Phone, Cell Phone, etc.
Later, when using this information, I would like to be able to select
"Home Phone" in the drop down box and have the number I typed in to be
displayed.
From what little I have learned about VLOOKUP, I have not seen this used.
I guessing the different phone numbers will need to be saved elsewhere in
the worksheet when I type them in ..
Can it be? How?