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?

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

On Tue, 24 Jun 2008 19:38:48 -0500, "HH" wrote:

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?