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?