Forum Discussion
Multiple Dependent Drop Down List to Filter Table
Hello Everyone,
I have created a spreadsheet that includes 3 dependent drop down lists using the Offset and Match functions. These are working with no issues. What I would like to do is to use those drop down lists to filter a table. The table would included categories from each of the 3 dependent drop down lists. Is this possible? I am using Excel version 2016/2019. Thank you for your assistance.
8 Replies
1) Would you like to filter the table when a value is selected in any of the three dropdowns, or only when a value is selected in the last of the three?
2) It would be helpful if you could attach a small sample workbook.
I have a dependent drop down list so it would be nice to filter each time one of the categories is selected. For example, the Main category once selected would filter the table for the category and so on for the Sub1 and Sub2. The Main categories Adhesives, Sealants & Fillers, Air Tools & Compressors and Automotive Tools are the only categories that are fully working through the Sub2 at this time. There is a VBA that resets Sub1 and Sub2 once the Main category is selected. Thank you for your assistance.
Thank you; I have downloaded the sample workbook.
Which sheet contains the table that you want to filter?
