Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down shows one value but inputs an alternate value
I would like to build a drop down menu that shows one value (ie the name) but
the value that is inputted in the table is the matching number to that name. Does anyone have any idea how to do this. My drop down lists are listed in the same file but a different worksheet then where the data is entered. Thanks!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down shows one value but inputs an alternate value
you could use a lookup formula, maybe give a little more info so somebody can post an example for you -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=530248 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down shows one value but inputs an alternate value
You can do this with programming. There's a sample file he
http://www.contextures.com/excelfiles.html Under Data Validation, look for 'Data Validation "Columns"' timber wrote: I would like to build a drop down menu that shows one value (ie the name) but the value that is inputted in the table is the matching number to that name. Does anyone have any idea how to do this. My drop down lists are listed in the same file but a different worksheet then where the data is entered. Thanks!!! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |