How to populate a cell with numeric value based on textselected from pull down in adjacent cell?

[Garth Rodericks]

How do I populate a cell with a numeric value based on the text selection from a pulldown in another cell?

For example, the values available from the cell pulldown in column A are "High", "Medium", and "Low".
I would like the adjacent cells in column B to populate with a numeric value based on what was selected from the pull downs in column A.
e.g. A B
High 5
Low 1
High 5
Medium 3
Medium 3

Can anyone help? Thanks!

 

[Max]

One way is to use VLOOKUP
Assuming the pulldowns are in A2 down
you could use this in B2:
=IF(A2="","",VLOOKUP(A2,{"High",5;"Medium",3;"Low",1},2,0))
Copy B2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700, Files:359, Subscribers:55
xdemechanik