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