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

Azkoyen City

Azkoyen M

Azkoyen Mistral

Azkoyen Palma H

Azkoyen Palma H Nano Sim Bianchi BVM 921 Bianchi BVM 931 Bianchi BVM 951 Bianchi BVM 952 Bianchi BVM 971 Bianchi BVM 972 Bravilor Esprecious <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

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?