Drop down menu / list
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? |
Drop down menu / list
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? |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com