I show you one method using the INDIRECT formula and TableRange in Excel to create your Multiple Dependent Drop-down list and within Google Sheets using the INDIRECT formula and NameRanges. Google Sheets has limitations but I show you a work around method to get the closest result similar to that on Excel.

Practice Workbook:
https://learnhowto.excelspreadsheet-support.com/create-multiple-dependent-dropdown-lists-using-indirect-formula/

Do you like what we offer? Please consider buying us a few coffees:
https://ko-fi.com/excelspreadsheetsupport

***TIMESTAMPS***
0:00 Introduction
0:25 How to create Multiple Dependent Drop-down list in Excel
6:00 How to create Multiple Dependent Drop-down list in Excel on every line
9:18 How to create Multiple Dependent Drop-down list in Google Sheets

EMAIL US:
[email protected]

********** SOFTWARE I USE FOR RECORDING AND EDITING **********
Screen & Audio Recorder & Video Editor (20% discount on first year subscription):
https://screencast-o-matic.com/refer/cY1nbsFTtL

Microsoft 365
https://microsoft-us.evyy.net/c/2379034/349129/3327

********* Let’s connect *********
LinkedIn: https://www.linkedin.com/company/excel-spreadsheet-support/
Facebook: https://www.facebook.com/excelspreadsheetsupport/
Products & Services: https://excelspreadsheet-support.com/
Portfolio: https://portfolio.excelspreadsheet-support.com/
How-To Lessons: https://learnhowto.excelspreadsheet-support.com/

#excelspreadsheetsupport #exceltutorials #excelbeginner #excelbeginners

Please take the opportunity to connect and share this video with your friends and family if you find it useful.