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.

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

_____________________________________________

🚩Let’s connect on social:

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

[jdavis]

Leila, you have a gift for clear explanations, thoughtful edits and on -screen presence. Keep up the great work!

[ahmedKorra]

I have been looking for something like that for a couple of days now, There is so many overly complicated ways out there but yours is simple and to the point

[juliestage]

That was incredible. This is exactly what I was looking for and it couldn’t have been explained any better. THANK YOU!

[philippanuda]

Thank you so much for this! I'm currently making my expenses tracker for 2023, and this is EXACTLY what I was looking for to categorize my expenses.

[lephork]

This is great. The explanation up front about the tabular format vs report format was key and missing from all the other videos I was trying to use. Your stuff is always great, thanks!

[jaduyare]

This will only work for one row. What if I want to add rows that will include the same function automatically without having to create new formulas, data prep columns, etc.?

[Kontroller]

Leila, you have explained this so clearly. It has been really helpful. Really the best guide on YouTube. Thanks 😊

[akhil]

This is simply awesome. Saved a lot of my time. Thank you for the video.

[wenzirv]

This video helped me SO much in a worksheet I'm creating. Thank you!

[KLuu]

WOW, I was breaking my head trying to use IF statement to do this and it is so simple.
Thank you, really helped me now.

[TylerStanczak]

Oh my gosh your intro is gold. Really helpful tutorial :)

[pavelahmed]

Very informative and easy to understand!

[lorenceonlinehome]

Very helpful, thanks. In my version of Google Spreadsheets, I had to replace the ", " between RANGE and CONDITION by ";".... Thanks for that support video!

[elluchocr]

This is GOLD!! Helped me alot. Thanks.

[RFC]

Thank you, short, intensive and informative

[gennarobasso]

you have made impressive and very helpful content on google sheets. Appreciate the videos

[syrupsyrup]

Exactly what I was looking for! Excellent!

[rajanghadi]

Simple and already well known by your teaching through excel videos, but still not less interesting the way video is presented. That really matters and is important.

Well done.

[CIKGUR]

THANK YOU LEILA...YOUR VID IS EXTREMELY HANDY!

[NVBeautyStudiosAndUniversity]

Do you have any tips for creating this formula but when you need to repeat the same dependent data validation over and over? I'm trying to create a payroll sheet that basically calculates each specific job performed.