| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop Down Box
I have Excel 2003. I have created several drop down boxes. I need to know
how to assign a value (ie a dollar amount) to each choice in the list. For instance, if a person picks option R1 from my 1st drop down box, I want R1 to have a value of $10.00, but if they pick P1, I want it to have a value of $5.00. This would go on for each drop down box. I currently have 3 total. Once a choice is made from each box, I want a dollar value created based upon their choices. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Threaded Mode
