Excel Drop Down Box

T

thefirstborn

I have Excel 2003. I have created several drop down boxes. I need to know
how to assign a value (ie a dollar amount) to each choice in the list. For
instance, if a person picks option R1 from my 1st drop down box, I want R1 to
have a value of $10.00, but if they pick P1, I want it to have a value of
$5.00. This would go on for each drop down box. I currently have 3 total.
Once a choice is made from each box, I want a dollar value created based upon
their choices.
 
L

Luke M

Create a table somewhere with the first column listing dropdown choices,
second column containing corresponding value. Formula then is:
=VLOOKUP(Drop_Down_Cell,Your_Table,2,FALSE)
 

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

Top