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: [ Ссылка ]

Multiple Dependent Drop-Down lists in Microsoft Excel:
[ Ссылка ]

свернуть