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

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!

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

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
---
<Garth Rodericks wrote in message
...
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!