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.

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.