Dynamic Dependent Dropdown Lists

This solution includes two files

- one file for two dropdown lists - category and subcategory - where the list of subcategories will depend on the category chosen.

- one file for three dropdown lists - category, subcategory and sub-subcategory - where the values for the subcategory list depend on the selected category and the values for the sub-subcategory depend on the values entered for the category and subcategory.

The user will use the file more appropriate each business case.

This first file contains:

- a sheet where the user enters all the combinations of categories and subcategories,

- an input sheet with the dropdown lists set up, and

- a sheet with all the supporting calculations to make the dropdown lists work.

This second file contains:

- a sheet where the user enters all the combinations of categories, subcategories and sub-subcategories,

- an input sheet with the dropdown lists set up, and

- a two sheets with all the supporting calculations to make the dropdown lists work.

This ensures your file is well organized and ready to be used.  You can modify the column headers as you wish. Start by entering your lists of categories and subcategories, and your dropdown lists will work immediately.

👉 Please note that this solution only works in Excel versions supporting Dynamic Array Functions:

✅ Excel for Microsoft 365

✅ Excel 2021

✅ Excel for the Web (available with free Microsoft accounts)

✅ Excel for Mobile Devices (iOS and Android)