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