INDIRECT function for multiple dependent lists

[Tom Arthur]

Hi,

Hoping somebody can help.

I'm trying to create multiple dependent dropdown lists.... but in this case they are not cascading.

How do I do this, since the Named Range of the Source would be the same for each of the dependent lists.  To explain further, these are my steps so far:

-Create Lists

-Format Lists as Tables

-Create Named Ranges

-Add Main Drop Down (using Data Validation)

-Add first Dependent Drop Down (using INDIRECT function with Data Validation)

-Add second Dependent Drop Down... same method, but since the 'Source' field is the main drop down again, it gives me the First rather than Second dependent list. Basically, I want BOTH dependent lists to be driven by the Main list choice, rather than dependent 1 informing dependent 2.

I hope this makes sense? I'd appreciate any advice... hopefully not too complex since I'm relatively new to Excel.

Thanks,

Tom

[#2]

Hi Tom

Maybe something like I've laid out in this article would help

https://accessanalytic.com.au/excel-dependent-drop-down-boxes/

Where in your case you'd have an extra column in your Primary table that referred to an extra list