| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display from dropdown
When creating a dropdown list, how can I have an item appear for choice but
output from choice an abbreviation? Example, I have a department list in namedrange DEPT. ACTG (Accounting) PURC (Purchasing) INVT (Inventory) I want the user to see Accounting, Purchasing, Inventory, but the output from their choice to be the appreviated version (ACTG, PURC, INVT). I don't want to display the entire thing to the user only the description. Any way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to limit columns that display based on selection of a dropdown value | Excel Worksheet Functions | |||
| Dropdown list doesn't display from the top of the list | Excel Discussion (Misc queries) | |||
| Display more than 8 lines in an Excel dropdown box | Excel Discussion (Misc queries) | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) | |||
Threaded Mode
