Linking numerical values to a text drop down box

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi

I have a drop down box in XL from which I'd like my
customers to make a text selection. Depending on which
text is selected, I'd like this to then equate to a number
which can be utilised in equations elsewhere in the
workbook.

For instance if they select "EASY" it equates to "1", if
they select "MEDIUM" it equates to "3" and if they
select "HARD" it equated to "7". I'd also like in the
future to be able to easily change these 1,3,7 numbers to
other numbers of my choosing

Any ideas would be greatfully received

Regards
Phil
 
Probably an easier way but you could run a simple vlookup.

A B C
1 Easy 1
2 Medium 3
3 Hard 7

Your input range would be column B which would give you the result of 1, 2, or 3
in your cell link. You could then have a vlookup in the cell of your choosing
( vlookup("cell link", A1:C3,3,false)) to give you your new value.
 
Back
Top