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

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

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

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

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

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

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