Title | : | Google Sheets - Dependent Drop Down Lists | 2 Ways |
Duration | : | 08:40 |
Viewed | : | 382,680 |
Published | : | 08-12-2020 |
Source | : | Youtube |
Join 400,000+ professionals in our courses here π https://link.xelplus.com/yt-d-all-courses 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. β¬οΈ DOWNLOAD the workbook here: https://pages.xelplus.com/sheets-dependent-dropdown 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. 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 LINKS to complete Google Sheets Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu _____________________________________________ β My Online Excel & Google Sheets Courses βΊ https://www.xelplus.com/courses/ β‘οΈ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join πβ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ π Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ π₯ RESOURCES I recommend: https://www.xelplus.com/resources/ π©Letβs connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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
![]() |
How To Create MULTIPLE Dependent Drop-Down List... 08:13 - 296,753 |
![]() |
Infinite Multiple Dependent Dropdown Lists In G... 11:36 - 3,018 |
![]() |
Awesome Trick to Get Dependent Drop Downs in Ex... 07:39 - 58,347 |
![]() |
Create SMART Drop Down Lists in Excel (with Dat... 15:42 - 838,683 |
![]() |
I Finally Got a Tesla Cybertruck and It Scares ... 12:42 - 716,412 |
![]() |
Google Sheets Query Function Explained 12:35 - 294,265 |
![]() |
Create Multiple Dependent Drop-Down Lists in Ex... 11:57 - 1,826,036 |
![]() |
How To Create ENDLESS Dependent Drop-Down Lists... 17:08 - 125,925 |