cell value based on combo box entry

[rdwngr23]

how can i get a specific value in a cell based on what is marked from a
checkbox?

if i have a combo box with 25, 30, 40 in cell b2 and i want cell b3 to
calculate a formula based on the "25" being checked (ie: if "25" is checked
multiply that (25) by 3.85)

am trying to use this for a home business - need help please!!!

 

[Sasa Stankovic]

hi,
my idea, when using combo box, is to link combo box with cell. So, each
change in combobox is written in cell.
and then you use that cell address in your formula! But, you need to "hide"
that cell by putting your combobox over it.
please send me an e-mail for example..

sasa

 

[Bob Phillips]

Link the combox to a cell, and then just use a simple lookup

=A2*LOOKUP(A2,{25,30,40},{3.85,4.25,2.75})

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[rdwngr23]

that should work but I have another hitch to this problem,

the "3.85" that I want the cell to recognize when "25" is checked on the
combo box comes from "sheet 2" of the workbook. What would happen if I change
the "3.85" to "8.75"? Would the Vlookup have to changed?

 

[Bob Phillips]

If you have a range of values on sheet2, better still, use

=A2*LOOKUP(A2,{25,30,40},Sheet2!B2:B4)


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[rdwngr23]

thanks for the help but i dont think im explaining what im looking for
correctly.

ill try new........

i put a combo box in cell B7 on sheet 1. That combo box has 3 choices, 25,30
or 40.
all 3 of them have a price on sheet 2.
sheet2 C4 is 3.87 for the 25
sheet2 C5 is 4.52 for the 30
sheet2 C6 is 6.38 for the 40.

what i would like is to have cell F7 on sheet1 automatically have the value
for the corresponding price based on what is selected in the combo box.

ie: 30 selected on combo box in cell B7, the value of 4.52 from sheet 2 C5,
would show in sheet1 F7.

hope this makes more sense on what i am trying to do.

if it would be faster please email me back at (e-mail address removed)

Thanks again

 

[rdwngr23]

thanks for the help but i dont think im explaining what im looking for
correctly.

ill try new........

i put a combo box in cell B7 on sheet 1. That combo box has 3 choices, 25,30
or 40.
all 3 of them have a price on sheet 2.
sheet2 C4 is 3.87 for the 25
sheet2 C5 is 4.52 for the 30
sheet2 C6 is 6.38 for the 40.

what i would like is to have cell F7 on sheet1 automatically have the value
for the corresponding price based on what is selected in the combo box.

ie: 30 selected on combo box in cell B7, the value of 4.52 from sheet 2 C5,
would show in sheet1 F7.

hope this makes more sense on what i am trying to do.

if it would be faster please email me back at (e-mail address removed)

Thanks again

 

[Bob Phillips]

=MATCH(B7,Sheet2!C4:C6,0)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[rdwngr23]

ok. maybe im a complete idiot here but everything that you are suggesting is
not working. im not sure if its just me or not. is there anyway i can send
you an example of what im trying to do and you could take a look at it and
show me that correct way to fix this problem?

i can be reached via email at (e-mail address removed)

thanks

 

[rdwngr23]

ok. maybe im a complete idiot here but everything that you are suggesting is
not working. im not sure if its just me or not. is there anyway i can send
you an example of what im trying to do and you could take a look at it and
show me that correct way to fix this problem?

i can be reached via email at (e-mail address removed)

thanks