Forum Discussion

Tom Arthur's avatar
Tom Arthur
Copper Contributor
Oct 02, 2018

INDIRECT function for multiple dependent lists

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

Resources