I am trying to make a triplet dependent drop-list. The first is a typical drop down but the next two are dynamic.
Since you cannot enter a formula into the data validation criteria, how can you create a drop-down box in the cell formula?
The examples I find often use "array formula"
=arrayformula(IF(A1="x", INDIRECT("NamedRangeX"), IF(...) ))
but using this function will not turn the cell into a drop-down list, it will fill in the cells below which is the wrong functionality.
What I need is something like this and to have it work with NamedRanges:
=droplist(IF(A1="x", INDIRECT("NamedRangeX"), IF(...) ))