Channel: Teacher's Tech

Category: Education

Tags: indirect function google sheetdata validationjamie keethow to use google sheetsgoogle sheets tutorial for beginnersdrop down listgoogle sheets tutorialteacher's tech tutorialsgoogle sheetsmultiple dependent drop-down lists google sheetsdata validation google sheets

Description: 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: docs.google.com/spreadsheets/d/1myzPvjXWePNLAIFKvht92eZWIZQkcuPomWCax6txpns/edit?usp=sharing Multiple Dependent Drop-Down lists in Microsoft Excel: youtu.be/oYF162_Cmwc