so, i created a dropdown list, then using the =INDIRECT function and named cells i created a dependent drop down from the first, works great! but now i want a third dropdown list off the first dropdown list. but when i try, excel just asks if i want to change the named cells.
I have created a mock up (attached)
the green list is fine and works as intended
the pale blue list should also work off the first but when i enter =indirect it just automatically uses the green list
Bookmarks