INDIRECT function for multiple dependent lists

%3CLINGO-SUB%20id%3D%22lingo-sub-265635%22%20slang%3D%22en-US%22%3EINDIRECT%20function%20for%20multiple%20dependent%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-265635%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EHoping%20somebody%20can%20help.%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20multiple%20dependent%20dropdown%20lists....%20but%20in%20this%20case%20they%20are%20not%20cascading.%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20this%2C%20since%20the%20Named%20Range%20of%20the%20Source%20would%20be%20the%20same%20for%20each%20of%20the%20dependent%20lists.%26nbsp%3B%20To%20explain%20further%2C%20these%20are%20my%20steps%20so%20far%3A%3C%2FP%3E%3CP%3E-Create%20Lists%3C%2FP%3E%3CP%3E-Format%20Lists%20as%20Tables%3C%2FP%3E%3CP%3E-Create%20Named%20Ranges%3C%2FP%3E%3CP%3E-Add%20Main%20Drop%20Down%20(using%20Data%20Validation)%3C%2FP%3E%3CP%3E-Add%20first%20Dependent%20Drop%20Down%20(using%20INDIRECT%20function%20with%20Data%20Validation)%3C%2FP%3E%3CP%3E-Add%20second%20Dependent%20Drop%20Down...%20same%20method%2C%20but%20since%20the%20'Source'%20field%20is%20the%20main%20drop%20down%20again%2C%20it%20gives%20me%20the%20First%20rather%20than%20Second%20dependent%20list.%20Basically%2C%20I%20want%20BOTH%20dependent%20lists%20to%20be%20driven%20by%20the%20Main%20list%20choice%2C%20rather%20than%20dependent%201%20informing%20dependent%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20makes%20sense%3F%20I'd%20appreciate%20any%20advice...%20hopefully%20not%20too%20complex%20since%20I'm%20relatively%20new%20to%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-265635%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266120%22%20slang%3D%22en-US%22%3ERe%3A%20INDIRECT%20function%20for%20multiple%20dependent%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266120%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Tom%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMaybe%20something%20like%20I've%20laid%20out%20in%20this%20article%20would%20help%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Faccessanalytic.com.au%2Fexcel-dependent-drop-down-boxes%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faccessanalytic.com.au%2Fexcel-dependent-drop-down-boxes%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhere%20in%20your%20case%20you'd%20have%20an%20extra%20column%20in%20your%20Primary%20table%20that%20referred%20to%26nbsp%3Ban%20extra%20list%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

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

1 Reply

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