Prev: Complex Counter
Next: How do I delete cell formats but not the content...
From: thefirstborn on 17 May 2010 11:20
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.
From: Luke M on 17 May 2010 12:38
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)

--
Best Regards,

Luke M
"thefirstborn" <thefirstborn(a)discussions.microsoft.com> wrote in message
news:5441DA55-D888-4833-A43A-813DB2A33D9C(a)microsoft.com...
>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.


From: Gord Dibben on 18 May 2010 12:09
=IF(A1="","",LOOKUP(A1,{"P1","Q1","R1"},{5,20,10}))


Gord Dibben MS Excel MVP


On Mon, 17 May 2010 08:20:01 -0700, thefirstborn
<thefirstborn(a)discussions.microsoft.com> wrote:

>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.

 | 
Pages: 1
Prev: Complex Counter
Next: How do I delete cell formats but not the content...