Google Sheets - Dependent Drop Down Lists | 2 Ways

Leila Gharani β€’ December 8, 2020
Video Thumbnail

About

No channel description available.

Video Description

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

Master Google Sheets Today

AI-recommended products based on this video

Loading...
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(3,057)
$15.99
Prime
200+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
Google Pixel Buds Pro 2 - Noise Canceling Earbuds - Up to 31 Hour Battery Life with Charging Case - Bluetooth Headphones - Compatible with Android - Hazel

Google Pixel Buds Pro 2 - Noise Canceling Earbuds - Up to 31 Hour Battery Life with Charging Case - Bluetooth Headphones - Compatible with Android - Hazel

(183)
199.99
PrimeFREE delivery Saturday, June 14
400+ bought in past month
Loading...
Deeyaple USB C to Aux, 4FT/1.2M, Type C to 3.5mm Audio Cable Headphone Jack Cable for Car Mobile Phone, iPhone 16 15, iPad Pro, Samsung Galaxy S24 S23 S2010, Google Pixel,Oneplus Grey (1)
Best Seller

Deeyaple USB C to Aux, 4FT/1.2M, Type C to 3.5mm Audio Cable Headphone Jack Cable for Car Mobile Phone, iPhone 16 15, iPad Pro, Samsung Galaxy S24 S23 S2010, Google Pixel,Oneplus Grey (1)

(78)
$6.99
FREE delivery Fri, Sep 5 on your first order
1K+ bought in past month
Loading...
Car Carplay Woven Cable for iPhone 16 15 3.3FT USB A to USB C 3.2 Gen 2 Carplay Adapter Wire for iPhone 16 15 Pro Max, iPad Pro/Air, Samsung Galaxy S25/S24/S23/S22/S21 Google Pixel, Car Charger Cable

Car Carplay Woven Cable for iPhone 16 15 3.3FT USB A to USB C 3.2 Gen 2 Carplay Adapter Wire for iPhone 16 15 Pro Max, iPad Pro/Air, Samsung Galaxy S25/S24/S23/S22/S21 Google Pixel, Car Charger Cable

(213)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month