Forum Discussion
Solved
Double INDIRECT quandary - probably trying to do summat stoopid again...
Hi Everyone - thank you for looking at this question. I am trying to do something 'clever' - and appear to be missing the mark! I am using a dependent drop-down (using INDIRECT within Data Valid...
David-W196 As I see it, what you call the volatile dropdown list refers to a named formula FRU. List in data validation must refer to ranges, named or direct references.
Since you tagged your original post with Office365, why not look into the functions UNIQUE and FILTER as demonstrated in the attached file.
If you start with Riny_van_Eekelen 's table, the columns may be made to be mutually dependent rather than a hierarchical dependence. It means that the options need to be cleared before setting out to choose something new but it does prevent the user from selecting
Salad - Beer
(as long as no-one puts mayo in my beer!)
- that's where I got to - please see my reply Riny_van_Eekelen of Nov 22 2021 03:48 AM