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)](https://i.ytimg.com/vi/7mo4COng7Sg/default.jpg)
![Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)](https://i.ytimg.com/vi/JTduguvrF34/default.jpg)
![Excel BEATS Google Sheets with THESE 10 Features!](https://i.ytimg.com/vi/yXMo9sj0Y2Y/default.jpg)
![Google Sheets - Dependent Dropdown List for Entire Column - App Scipt, Run On User Input - Part 1](https://i.ytimg.com/vi/1SIN5NyQ9fw/default.jpg)
![Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)](https://i.ytimg.com/vi/UsdedFoTA68/default.jpg)
![Excel LAMBDA - HOW & WHEN you Should use it](https://i.ytimg.com/vi/Rm4y5UqauRw/default.jpg)
![Google Sheets BEATS Excel with THESE 10 Features!](https://i.ytimg.com/vi/n2DxXffRxBM/default.jpg)
![6 FREE Add-Ins for Excel to Start Using Now](https://i.ytimg.com/vi/nXGPz1ETzWI/default.jpg)
![Excel Conditional Formatting with Formula | How to Get it RIGHT Every Time](https://i.ytimg.com/vi/XHT4paRaY4g/default.jpg)
![Google Sheets - Dependent Drop Down List for Entire Column, Multiple Levels](https://i.ytimg.com/vi/s-I8Z4nTDak/default.jpg)
![Properly Convert PDF to Excel](https://i.ytimg.com/vi/p2304BjvrB8/default.jpg)
![4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1](https://i.ytimg.com/vi/tGY70sdpaLc/default.jpg)
![Searchable Drop Down List in Excel (Very Easy with FILTER Function)](https://i.ytimg.com/vi/Z-h2UER3b_0/default.jpg)
![Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)](https://i.ytimg.com/vi/xnLvEhXWSas/default.jpg)
![Advanced PivotTable Techniques: Combine Data from Multiple Sheets in Excel](https://i.ytimg.com/vi/mTdIEhtcqlo/default.jpg)
![Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)](https://i.ytimg.com/vi/gu4xJWAIal8/default.jpg)
![OFFSET Function - Google Sheets](https://i.ytimg.com/vi/xVGR0vbOnLk/default.jpg)
![Excel FILTER Function TRICK for Non Adjacent Columns](https://i.ytimg.com/vi/Onudkw9DMlU/default.jpg)
![Excel Dynamic Chart with Drop down List (column graph with average line)](https://i.ytimg.com/vi/22jcw5slQJk/default.jpg)
![Create SMART Drop Down Lists in Excel (with Data Validation)](https://i.ytimg.com/vi/FRiFfKb_B_A/default.jpg)