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

  • Thread starter Garth Rodericks
  • Start date
G

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!
 
M

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
 

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

Conditional formatting based on adjacent cell? 1
Reference the same cell based on tab name 1
nested if statements - multiple variables 1
How to assign values to a cell based on values in another cell? 1
Result from data in two columns....Best function to use? 5
I need to switch currencies based on a pull-down selection 10
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
=Large function returns #NUM! 5

Top