Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with multiple function from drop down box
i have a drop down box with 3 items say A,B,C then i need the following to
operate from that single dropdown box as follows: (if A4=A then A6=D9,B6=D10,C6=D11) (if A4=B then A6=D12,B6=D13,C6=D14) (if A4=C then A6=D15,B6=D16,C6=D17) any ideas please -- BD3 |
#2
|
|||
|
|||
Hi
One way, IF the entries in A4 are ALWAYS uppercase, A,B, or C A6=INDIRECT("D"&9+3*(CODE(A4)-65)) B6=INDIRECT("D"&10+3*(CODE(A4)-65)) C6=INDIRECT("D"&11+3*(CODE(A4)-65)) Regards Roger Govier bigdaddy3 wrote: i have a drop down box with 3 items say A,B,C then i need the following to operate from that single dropdown box as follows: (if A4=A then A6=D9,B6=D10,C6=D11) (if A4=B then A6=D12,B6=D13,C6=D14) (if A4=C then A6=D15,B6=D16,C6=D17) any ideas please |
#3
|
|||
|
|||
Hi,
A6: =IF($A4="A",$D9,IF($A4="B",$D12,$D15)) B6: =IF($A4="A",$D10,IF($A4="B",$D13,$D16)) C6: =IF($A4="A",$D11,IF($A4="B",$D14,$D17)) Regards, Stefi bigdaddy3 ezt *rta: i have a drop down box with 3 items say A,B,C then i need the following to operate from that single dropdown box as follows: (if A4=A then A6=D9,B6=D10,C6=D11) (if A4=B then A6=D12,B6=D13,C6=D14) (if A4=C then A6=D15,B6=D16,C6=D17) any ideas please -- BD3 |
#4
|
|||
|
|||
sorry roger when i used a,b,c it was just an example the actual item will be
say weekly,monthly etc. and if that code would do the job where would it be put -- BD3 "Roger Govier" wrote: Hi One way, IF the entries in A4 are ALWAYS uppercase, A,B, or C A6=INDIRECT("D"&9+3*(CODE(A4)-65)) B6=INDIRECT("D"&10+3*(CODE(A4)-65)) C6=INDIRECT("D"&11+3*(CODE(A4)-65)) Regards Roger Govier bigdaddy3 wrote: i have a drop down box with 3 items say A,B,C then i need the following to operate from that single dropdown box as follows: (if A4=A then A6=D9,B6=D10,C6=D11) (if A4=B then A6=D12,B6=D13,C6=D14) (if A4=C then A6=D15,B6=D16,C6=D17) any ideas please |
#5
|
|||
|
|||
Hi Stefi, that works fine thankyou .
-- BD3 "Stefi" wrote: Hi, A6: =IF($A4="A",$D9,IF($A4="B",$D12,$D15)) B6: =IF($A4="A",$D10,IF($A4="B",$D13,$D16)) C6: =IF($A4="A",$D11,IF($A4="B",$D14,$D17)) Regards, Stefi bigdaddy3 ezt *rta: i have a drop down box with 3 items say A,B,C then i need the following to operate from that single dropdown box as follows: (if A4=A then A6=D9,B6=D10,C6=D11) (if A4=B then A6=D12,B6=D13,C6=D14) (if A4=C then A6=D15,B6=D16,C6=D17) any ideas please -- BD3 |
#6
|
|||
|
|||
Hi
No, I was basing it on you literally using A,B and C. In which case as each of the cell values was being offset by 3, dependent upon the lookup value, I was trying to avoid IF statements by using the fact that CODE(A) is 65, B is 66 etc, hence taking away 65 would leave you with 0 1 or 2 to multiply by 3, giving D (9+3*0)=9, (9+3*1)=12, and (9+3*2) =15. It will not work in the scenario you describe, and I can see that Stefi has posted you a correct solution with IF statements. Regards Roger Govier bigdaddy3 wrote: sorry roger when i used a,b,c it was just an example the actual item will be say weekly,monthly etc. and if that code would do the job where would it be put |
#7
|
|||
|
|||
hi roger
thanks for your input anyway. -- BD3 "Roger Govier" wrote: Hi No, I was basing it on you literally using A,B and C. In which case as each of the cell values was being offset by 3, dependent upon the lookup value, I was trying to avoid IF statements by using the fact that CODE(A) is 65, B is 66 etc, hence taking away 65 would leave you with 0 1 or 2 to multiply by 3, giving D (9+3*0)=9, (9+3*1)=12, and (9+3*2) =15. It will not work in the scenario you describe, and I can see that Stefi has posted you a correct solution with IF statements. Regards Roger Govier bigdaddy3 wrote: sorry roger when i used a,b,c it was just an example the actual item will be say weekly,monthly etc. and if that code would do the job where would it be put |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is a Drop Down box the best function to use? | Excel Discussion (Misc queries) | |||
how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) | |||
multiple drop down lists | Excel Discussion (Misc queries) | |||
SumIf Function using multiple criteria | Excel Worksheet Functions | |||
drop down list multiple columns | Excel Discussion (Misc queries) |