I am creating a template that contains multiple, dependent drop-down lists. If you choose a certain thing in the first list, it will only show options related to that choice in the second drop-down, and so on. The items in my 3rd list all contain a different number of populated cells. When I set up the formula, it captures the whole table rather than just showing the cells with data based on what column it is. I end up with blanks as choices in the 3rd drop down. Based on what is chosen in the 2nd drop-down, how do I only see those choices in the 3rd drop-down rather than blanks as well?
Here is my current formula and the example is attached.
Hereto attached is the file with the dynamic dependent drop-down list you need. Aside from your given data, I added Beverages as a category, along with the corresponding subcategories and items, to the Data sheet.
Being dynamic, you can add (or delete) categories, subcategories, and items in the Data sheet without any required modification in the formula. Download it and inform me of your thoughts about it.
You just have to rename the Data sheet and the workbook name in me uploaded file. The layout of your data and drop-down list must be strictly in accordance with mine so that the formulas will deliver the expected results.