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

T

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Drop Down Menu 1
Change drop down list in one cell based on values in other cells 2
How do I give numerical values to each text item in a list 1
formulae in excel worksheets 4
Best method to populate cell based upon drop down list selection 4
How to equate Text Drop Down selections to numerical values 3
Creating drop downs in a cell contingent on another drop down 1
Calculating numerical month (1 to 12) from text date 4

Top