Forum Discussion
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...
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