How to populate a cell with numeric value based on text

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!

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
news:200894205230garth_rodericks@yahoo.com...
> 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!