Assign numerical value to cell based on selection from drop-down m

[Tim]

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.

 

[Gord Dibben]

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