Conditional Drop down boxes from 3 tables

[Martynrbell]

Hi All,

I am setting up an order form which has a few dependant dropdown boxes.

So far i have set up my first two boxes

Im having an issue in where my drop down box has the following 3 options

Telemetry
Atto
NanoSim
NanoLan

I need the box after this to then pull data from the tables which go with the options

Atto
AMS Sensit II
API 1xx
API 2xx
API Ultraflex

Nano Lan
[TABLE="width: 246"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Azkoyen City [/TD]
[/TR]
[TR]
[TD]Azkoyen M[/TD]
[/TR]
[TR]
[TD]Azkoyen Mistral[/TD]
[/TR]
[TR]
[TD]Azkoyen Palma H [/TD]
[/TR]
[TR]
[TD]Azkoyen Palma H

Nano Sim
[TABLE="width: 246"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Bianchi BVM 921[/TD]
[/TR]
[TR]
[TD]Bianchi BVM 931[/TD]
[/TR]
[TR]
[TD]Bianchi BVM 951[/TD]
[/TR]
[TR]
[TD]Bianchi BVM 952[/TD]
[/TR]
[TR]
[TD]Bianchi BVM 971[/TD]
[/TR]
[TR]
[TD]Bianchi BVM 972[/TD]
[/TR]
[TR]
[TD]Bravilor Esprecious[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]




I have tried using the indirect command however it only seems to pull the data when ATTO is selected.

FYI this is the third dropdown box in a row

Any ideas would be appreciated.

Thanks
Martyn

 

[Dan5977]

INDIRECT is the way to go I would say. Have you set up named ranges for "Atto", "Nano Lan" & "Nano Sim"?

Try it with a helper column. I don't know if a drop down referencing from another may be the problem and unfortunately I don't have time to check right now. If you create an adjacent column that = what is selected in the drop down and then perform the INDIRECT command on that does it work?