Create Multiple Dependent Dropdown Lists using INDIRECT formula

Learn to create a multiple dependent dropdown list from scratch. We provide a “step by step” process using the indirect formula that has been taught in INDIRECT formula.  

To further assist with the tutorial,  a practice workbook is also provided for all to follow along as we at ESS believe that you learn by doing.

Content covered in tutorial

  • Create multiple dependent dropdown list in Excel
  • Create multiple dependent dropdown list in Excel on multiple rows
  • Create multiple dependent dropdown list in Google Sheets
Download “Multiple Dependent Dropdown List INDIRECT Practice Workbook” Multiple-Dependent-Dropdown-INDIRECT-v2.0.xlsx – Downloaded 2604 times – 131.25 KB

Related Tutorials

Learn how to create a "NESTED IF with AND" formula...

Learn how to create Multiple dependent dropdown lists using MATCH,...

Learn how to use the INDIRECT formula.

Learn how to use AND, OR, IF and IFERROR formulas...