Multiple Dependent Drop Down List to Filter Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2448638%22%20slang%3D%22en-US%22%3EMultiple%20Dependent%20Drop%20Down%20List%20to%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2448638%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%20Everyone%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20created%20a%20spreadsheet%20that%20includes%203%20dependent%20drop%20down%20lists%20using%20the%20Offset%20and%20Match%20functions.%20These%20are%20working%20with%20no%20issues.%20What%20I%20would%20like%20to%20do%20is%20to%20use%20those%20drop%20down%20lists%20to%20filter%20a%20table.%20The%20table%20would%20included%20categories%20from%20each%20of%20the%203%20dependent%20drop%20down%20lists.%20Is%20this%20possible%3F%20I%20am%20using%20Excel%20version%202016%2F2019.%20Thank%20you%20for%20your%20assistance.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2448638%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2448732%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Dependent%20Drop%20Down%20List%20to%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2448732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1079306%22%20target%3D%22_blank%22%3E%40m1975michael%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20Would%20you%20like%20to%20filter%20the%20table%20when%20a%20value%20is%20selected%20in%20any%20of%20the%20three%20dropdowns%2C%20or%20only%20when%20a%20value%20is%20selected%20in%20the%20last%20of%20the%20three%3F%3C%2FP%3E%0A%3CP%3E2)%20It%20would%20be%20helpful%20if%20you%20could%20attach%20a%20small%20sample%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2449019%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Dependent%20Drop%20Down%20List%20to%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2449019%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20a%20dependent%20drop%20down%20list%20so%20it%20would%20be%20nice%20to%20filter%20each%20time%20one%20of%20the%20categories%20is%20selected.%26nbsp%3B%20For%20example%2C%20the%20Main%20category%20once%20selected%20would%20filter%20the%20table%20for%20the%20category%20and%20so%20on%20for%20the%20Sub1%20and%20Sub2.%26nbsp%3B%20The%20Main%20categories%26nbsp%3BAdhesives%2C%20Sealants%20%26amp%3B%20Fillers%2C%20Air%20Tools%20%26amp%3B%20Compressors%20and%20Automotive%20Tools%20are%20the%20only%20categories%20that%20are%20fully%20working%20through%20the%20Sub2%20at%20this%20time.%26nbsp%3B%20There%20is%20a%20VBA%20that%20resets%20Sub1%20and%20Sub2%20once%20the%20Main%20category%20is%20selected.%20Thank%20you%20for%20your%20assistance.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2449109%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Dependent%20Drop%20Down%20List%20to%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2449109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1079306%22%20target%3D%22_blank%22%3E%40m1975michael%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%3B%20I%20have%20downloaded%20the%20sample%20workbook.%3C%2FP%3E%0A%3CP%3EWhich%20sheet%20contains%20the%20table%20that%20you%20want%20to%20filter%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2449370%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Dependent%20Drop%20Down%20List%20to%20Filter%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2449370%22%20slang%3D%22en-US%22%3EIdeally%20it%20would%20be%20the%20sheet%20called%20TableWithDropDown%20if%20not%20the%20the%20Table%20sheet.%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@m1975michael 

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.

@Hans Vogelaar 

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.

@m1975michael 

Thank you; I have downloaded the sample workbook.

Which sheet contains the table that you want to filter?

Ideally it would be the sheet called TableWithDropDown if not the the Table sheet.
Were you able to fine a solution?

@m1975michael My apologies, this thread somehow dropped of my radar.

 

Your dependent dropdowns are already working correctly. I don't understand what or how you want to filter. Can you explain?

Thank you Hans for replying back to me. I will eventually have a big table of data that I would like to filter using my dependent dropdowns. I realize that I may need to use different sheets or layout in excel to make this possible. I will be happy anyway we can get it working.

@m1975michael 

Your current setup doesn't have anything like that, so I have no idea.