Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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 "rdwngr23" wrote in message ... 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!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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" wrote in message ... 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!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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" wrote: 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" wrote in message ... 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!!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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" wrote in message ... 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" wrote: 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" wrote in message ... 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!!! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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 Thanks again "Bob Phillips" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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!!! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
=MATCH(B7,Sheet2!C4:C6,0)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rdwngr23" wrote in message ... 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 Thanks again "Bob Phillips" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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!!! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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 thanks "Bob Phillips" wrote: =MATCH(B7,Sheet2!C4:C6,0) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rdwngr23" wrote in message ... 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 Thanks again "Bob Phillips" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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!!! |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on combo box entry
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 thanks "Bob Phillips" wrote: =MATCH(B7,Sheet2!C4:C6,0) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rdwngr23" wrote in message ... 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 Thanks again "Bob Phillips" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default colour in cell based on specific entry | Excel Worksheet Functions | |||
auto population based on single cell entry | Excel Discussion (Misc queries) | |||
Formula to fill a cell based on an entry in one of two worksheets | Excel Worksheet Functions | |||
Formula based on a cell entry | Excel Discussion (Misc queries) | |||
Prevent entry based on another cell value | Excel Worksheet Functions |