| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign numerical value to cell based on selection from drop-down m
I want to assign a numerical value to a cell based on the selection of one of
eleven options within a drop-down menu. This numerical value will be used in a formula within the worksheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assign numerical value to cell based on selection from drop-down m
You could set up a Lookup table and use the results of a VLOOKUP formula as
the numerical value to be referenced elswhere. Either as a cell reference or in your formula. Or use a formula like such. =LOOKUP(A1,{"a","b","c","d","e","f","g","h","i","j ","k"},{1,2,3,4,5,6,7,8,9,10,11})*B1 Gord Dibben MS Excel MVP On Tue, 6 Apr 2010 11:18:01 -0700, Tim wrote: I want to assign a numerical value to a cell based on the selection of one of eleven options within a drop-down menu. This numerical value will be used in a formula within the worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best method to populate cell based upon drop down list selection | Excel Discussion (Misc queries) | |||
| cell value based on selection from drop box | Excel Worksheet Functions | |||
| Hide row(s) based on drop down selection | Excel Discussion (Misc queries) | |||
| How do I assign a set of values to a selection from a drop list? | New Users to Excel | |||
| Drop Down Lists - assign a value based on selection | Excel Worksheet Functions | |||
Hybrid Mode
