Forum Discussion
Solved
Data validation lists - flow chart?
Hello, I'm a school leader and I'm trying to create an Excel spreadsheet to track Teaching & Learning action steps that I give to teachers. I understand how to create a drop down list but what I'...
Hello Phoebe,
What you need is a dynamic dependent drop-down list. In the attached file, I inserted Lists sheet. You can add (or delete) categories of Dimensions of Depth and Dimension Focus. There is no more need to define additional named ranges.
Though I had seen this problem before! Now I can see whether I use the same methods from time to time; the answer being I do not.
Last time I used CHOOSE, this time a function I use only rarely, namely INDIRECT. I notice that I also consolidated the Action lists into tables. In the unlikely event of there being any calculation to aggregate the results this will provide a meaningful way of referencing statements.
Maybe @Twifoo is more consistent. I will take a look.
- We’ve been through this before. Perhaps, your second look, just like anything else, will be better than the first one. So do I.