In this video tutorial, I will show you how to create multiple dependent dropdown lists in Google Sheets. Using data validation and the INDIRECT function in Google Sheets allows you to create dropdown lists from named ranges. This makes a simple and quick way to make a dependent dropdown list but it’s not without limitations. I will go over these issues and explain why you may not want to use this method.

Google Sheet Practice Sheet: https://docs.google.com/spreadsheets/...

Multiple Dependent DropDown lists in Microsoft Excel:
   • Quickly Create Multiple Dependent Dro...