Google Sheets - Dependent Drop Down Lists | 2 Ways
Learn how to create dependent dropdown data validation lists in Google Sheets and have different drop-down values based on the value of another cell. Basically the second drop down depends on the value of the first drop-down. Once we have the first drop down menu setup, we will create a dynamic dependent drop-down list that's based on the value of the first drop-down.
There are different ways you can get this done depending on how your data is setup. If you have a tabular data set you might need another function than if your data is organized across multiple columns. I show 2 different ways of creating the dependent dropdown list depending on your setup.
Time Stamps
00:00 Dependent Drop-Down Lists in Google Sheets
01:06 Dependent Drop-Down Lists in Google Sheets with Tabular Data
05:05 Dependent Drop-Down Lists in Google Sheets with Data in Report Format
⯆ DOWNLOAD a copy of the file here: https://www.xelplus.com/google-sheets-dependent-drop-down-lists (scroll to the bottom of the blog post)
LINKS to complete Google Sheets Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu
_____________________________________________
★ My Online Excel & Google Sheets Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#googlesheets
Видео Google Sheets - Dependent Drop Down Lists | 2 Ways канала Leila Gharani
There are different ways you can get this done depending on how your data is setup. If you have a tabular data set you might need another function than if your data is organized across multiple columns. I show 2 different ways of creating the dependent dropdown list depending on your setup.
Time Stamps
00:00 Dependent Drop-Down Lists in Google Sheets
01:06 Dependent Drop-Down Lists in Google Sheets with Tabular Data
05:05 Dependent Drop-Down Lists in Google Sheets with Data in Report Format
⯆ DOWNLOAD a copy of the file here: https://www.xelplus.com/google-sheets-dependent-drop-down-lists (scroll to the bottom of the blog post)
LINKS to complete Google Sheets Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu
_____________________________________________
★ My Online Excel & Google Sheets Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#googlesheets
Видео Google Sheets - Dependent Drop Down Lists | 2 Ways канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)Excel BEATS Google Sheets with THESE 10 Features!Google Sheets - Dependent Dropdown List for Entire Column - App Scipt, Run On User Input - Part 1Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Excel LAMBDA - HOW & WHEN you Should use itGoogle Sheets BEATS Excel with THESE 10 Features!6 FREE Add-Ins for Excel to Start Using NowExcel Conditional Formatting with Formula | How to Get it RIGHT Every TimeGoogle Sheets - Dependent Drop Down List for Entire Column, Multiple LevelsProperly Convert PDF to Excel4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Searchable Drop Down List in Excel (Very Easy with FILTER Function)Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)Advanced PivotTable Techniques: Combine Data from Multiple Sheets in ExcelExcel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)OFFSET Function - Google SheetsExcel FILTER Function TRICK for Non Adjacent ColumnsExcel Dynamic Chart with Drop down List (column graph with average line)Create SMART Drop Down Lists in Excel (with Data Validation)