In this video tutorial, I will show you how to create multiple dependent drop-down lists in Google Sheets. Using data validation and the INDIRECT function in Google Sheets allows you to create drop-down lists from named ranges. This makes a simple and quick way to make a dependent drop-down 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/d/1myzPvjXWePNLAIFKvht92eZWIZQkcuPomWCax6txpns/edit?usp=sharing

Multiple Dependent Drop-Down lists in Microsoft Excel:
https://youtu.be/oYF162_Cmwc