No video :(

Google Sheets - Dependent Drop Down Lists | 2 Ways

Подписаться 2,7 млн

Просмотров 397 тыс.

50% 1

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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: pages.xelplus.com/sheets-depe...
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: • Google Sheets Tips, Tr...
_____________________________________________
★ My Online Excel & Google Sheets Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / 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

Опубликовано:

8 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 260

@LeilaGharani 6 месяцев назад

Grab the file I used in the video from here 👉 pages.xelplus.com/sheets-dependent-dropdown

@fadly1896 3 месяца назад

When i click data validation, there is a pop up appear from side screen, not a dialog box like yours, why is that?

@rmndvprz 3 месяца назад

@@fadly1896 This video was 3 years ago. Google has made several visual updates, and that included the side-bar/screen instead of a pop-up.

@fadly1896 3 месяца назад

@@rmndvprz i see, thank you

@meganesguerra7540 3 месяца назад

Is there any way you can do that repeatedly? E.g. the data validation options would be from A1:A10 (category) and B1:B10 (subcategory)?

@egymade 2 месяца назад

@@meganesguerra7540 came to know the same thing. it only works for 1 cell!

@jdavis6650 Год назад

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

@juliestage9773 2 года назад

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

@ahmedKorra1 3 года назад

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

@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.

@user-le8ph6or6k 11 месяцев назад

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!

@Kontroller100 8 месяцев назад

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

@TylerStanczak 3 года назад

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

@LeilaGharani 3 года назад

Glad you think so!

@jaduyare 6 месяцев назад

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.?

@akashrathore5970 3 месяца назад

Same issue with me

@agustingavina9011 День назад

It seems she left that part for a second video, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ku17vgq4Q14.html

@3KLuu 9 месяцев назад

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.

@NVBeautyStudiosAndUniversity 2 года назад

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.

@adrianodvo Год назад

I believe this video will solve your problem: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ku17vgq4Q14.html

@CIKGUR 3 месяца назад

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

@dew3968 3 года назад

I love you. Sooo glad I found this channel at 4:47am. Thank you.

@LeilaGharani 3 года назад

Welcome! You're up early 😴

@rajanghadi2337 3 года назад

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.

@LeilaGharani 3 года назад

So nice of you!

@egymade 2 месяца назад

@@LeilaGharani do you know how to do it for the entire column? the video made it for 1 cell only and doesn't work for the rest of the column!

@user-we1nz8ir8v 10 месяцев назад

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

@akhil11320 2 года назад

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

@itsgreysbee 4 месяца назад

Big help. This video is simple and understandable for beginners like me. Thanks.

@gennarobasso144 Год назад

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

@measureQuick 3 месяца назад

So helpful. This was exactly what I needed. 5 stars!!!!

@syrupsyrup335 Год назад

Exactly what I was looking for! Excellent!

@elluchocr5596 3 года назад

This is GOLD!! Helped me alot. Thanks.

@pavelahmed1633 3 года назад

Very informative and easy to understand!

@MaralSabbagh 3 года назад

This tutorial just saved a lot of waste of energy trying to experiment...Thanks a lot you're a LIFE SAVER ! +1 sub

@LeilaGharani 3 года назад

Thanks for the sub!

@RFC2014 3 года назад

Thank you , short , intensive and informative

@michaeljenssen8976 Месяц назад

Thx for keeping everything in one sheet in this tutorial😊

@germaincharlie2277 2 года назад

Nice video like always , your channel is my go to for any google sheet magic trip

@arsenigold9470 5 месяцев назад

Exactly what I needed you are a saviour! UPD: I left the comment before watching the video, but as soon as you clarified that the data will be in the separate sheet, OMG just chefs kiss!

@LeilaGharani 5 месяцев назад

Glad it was helpful.

@mohamedzaneer3065 Год назад

Thanks Leila. wonderful explation

@johnaffolder5605 3 года назад

Thank you. I did not want the second drop down, just one to fill the adjacent cell. I reworked your formula just a bit and it worked. Filter was what I needed not Vlookup what many others were showing, but didn’t work for me. Why it worked for them but not me, I don’t have a clue why. A lesson learned to watch your tutorials first. I still have to work out the #NA that is in the cell when nothing is chosen but will find a fix.

@TwooPoint0 Месяц назад

Very clear and concise explanation. I really appreciate you putting this together.

@LeilaGharani Месяц назад

Glad you enjoyed it!

@StuMorris Год назад

Amazing, solved my problem. Super simple and clear to follow.

@egymade 2 месяца назад

do you know how to do it for the entire column? the video made it for 1 cell only and doesn't work for the rest of the column!

@lorenceonlinehome 2 года назад

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

@hegekrisz4787 5 месяцев назад

Thank you very much Leila , that was very helpfull. :)

@gabriel.valandro 2 года назад

Wow, your explanation is priceless! Thank you so much :))

@LeilaGharani 2 года назад

You're very welcome!

@michaelangelo9702 4 месяца назад

very helpful! it took me a while to figure it out but it worked!

@Dipenparmar12 Год назад

Amazing thanks for your nice and neat tutorial. love it

@ZaileeRamsey Год назад

Thanks. Just what I needed.

@wayneedmondson1065 3 года назад

Thanks Leila. I'm liking what I see in Google Sheets. I hope some of the innovations make it over to EXCEL. Thanks for sharing your tips :)) Thumbs up!!

@LeilaGharani 3 года назад

I hope so too, Wayne!

@derekalcorn3 2 года назад

This is exactly what I was looking for. Thanks Leila

@LeilaGharani 2 года назад

You’re welcome 😊

@alvicmariefrancisco5088 2 месяца назад

thank you so much for this info!

@farshidmkhn4409 Год назад

thank you dear leila, it was so helpful

@learnwithsauravsharma 2 месяца назад

You nicely explained what i needed thank u so much.

@DougHExcel 3 года назад

Great instructions on the different ways to create this!

@LeilaGharani 3 года назад

Thanks Doug :)

@mangafreak5514 Год назад

Thank you so much.. I was trying to do this using name list bcz of some certen video.. I was trying more than 3h.. You just save me

@fayeduclayan7629 2 года назад

Thanks for this! very helpful

@peter102 8 месяцев назад

great video. helped me with something i was stuck on

@amajidkhan1978 10 месяцев назад

very nice and clear explanation . Great work🎉.... keep it up. Love from India❤

@Nacho-WhatDoWePlayNext 3 года назад

A mind-blowingly simple explanation for something that has been a hurdle for me. THANK YOU.

@LeilaGharani 3 года назад

You're very welcome!

@Digitall3 2 года назад

this is fantastic, thank you!

@nickyp1765 2 года назад

Thanks for that. Perfect explanation and so useful. So used to Excel that I find it hard with the small bit in Google Sheets!

@vwvMARDUK 5 месяцев назад

This is awesome quality material. Thank you!

@LeilaGharani 5 месяцев назад

Glad you enjoyed it!

@Blinks77 Год назад

That was excellent. Thankyou.

@akin-ojoayotomide8909 6 месяцев назад

Thank you so much for this!

@matthewmorrisson1806 7 месяцев назад

That's exactly what I needed and w/o a bunch of complex lookup tables. Thanks!!

@egymade 2 месяца назад

do you know how to do it for the entire column? the video made it for 1 cell only and doesn't work for the rest of the column!

@matthewmorrisson1806 2 месяца назад

@@egymade I don't think I'm following your question. This video showed how to insert a dropdown into a single cell that referenced a column of data. What are you trying to do in the entire column?

@egymade 2 месяца назад

@@matthewmorrisson1806 thanks for reply, appreciated! I wanna create 2 full columns not just 1 cell. The 1st column is a drop down menu which is easy to do.. The 2nd is the dependent menu on the 1st column.. So whenever I choose any cell of the 1st column the corresponding cell changes in the 2nd.

@IsabelExplains Год назад

This is genius! Thank you! 🙏

@faridi-bin-Zouq 3 года назад

It is always pleasant to watch Your videos.....Thanks -- From Pakistan

@LeilaGharani 3 года назад

I'm glad to hear that :)

@IslamQuranMuslim 3 года назад

Thanks a lot, I tried for this.

@nupursingh9543 Год назад

Very nicely explained

@mattinikcube Год назад

I just loving you now. really what I needed

@DiazFelix 3 года назад

Thanks a lot for the tip. I did it long time ago using javascript code in gcode, but this method seems more readable.

@LeilaGharani 3 года назад

Great to hear, Félix!

@user-fw2oz8xz6f 6 месяцев назад

Thank You So Much ,

@BetterSheets 3 года назад

This makes google sheets sooio much more interactive.

@Prankmonkey714 2 года назад

I suck at spreadsheets. Every time I create one it is as if I'm using the program for the first time. After his video I accomplished at task in Sheets that I had never successfully applied before. Leila is brilliant, concise and beautiful. A combination that kept me focused on the task at hand resulting in exactly what I had been attempting for far too long

@philipsheppard953 4 месяца назад

haha not sure the "beautiful" remark was necessary, but you got a heart! It's a great video! Just want to know whether i can do multiple rows with the same data validation or not

@PankajGupta-yx6mu Год назад

Hi Leila, I saw your video on Creating Dropdown lists in google sheets. In your video, you have shown the drop-down lists created in just two cells side by side, for example, A2 and B2. What if you want to create a series of drop-down lists across the entire column downwards. I'm trying to create an Operator Efficiency Monitoring Sheet, wherein, we have a Part Name and the drop-down dependent list I want to create is the List of Operations, that goes into making that particular Part. I have a multiple list of parts and on a daily basis, different parts are produced. So I want a matrix form of a sheet wherein every day, you select a different Part Name and its corresponding drop-down list opens. How will the Prep column behave in this case.

@vascovasconcelos1783 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ku17vgq4Q14.html&ab_channel=LeilaGharani

@BangaliBabuVlogs 8 месяцев назад

exactly my question too

@Kontroller100 8 месяцев назад

Leila explains this in the next video. Using transpose to make the list go horizontally across columns, then use this range as the source of the dropdown. It definitely works!

@Knebelcm1986 Год назад

Finally found a good video for this

@checkpte8475 2 года назад

excellent, you have earned a subscribition and a comment

@lorenvillaverde2564 4 месяца назад

The formula works and I am thrilled how you simplified the tutorial! I wonder, how can I replicate the single cell example into multiple dropdowns?

@02buddha02 3 года назад

Leila... You are the freaking best

@kakasantos8545 2 месяца назад

Tem meu Jóia!!!

@RajendraPatel. 3 года назад

It's really awesome 😉🙏🙏

@bilalperouz9739 3 месяца назад

Thanks for the helpful tutorial, can we add date also in this drop down i mean like manual date?

@abdidekmuhumed4510 3 года назад

Great, extremly like this

@kshusker001 10 месяцев назад

This is a great video. Thank you so much for sharing. How do you add options to the dependent list?

@justinmacrae7430 Год назад

Thank you so much!

@vanik9432 Год назад

Helped alot! :)

@user-kc9yr7hd2q Год назад

Hi Leila! thank you so much! Whats the link to the video where you explain how to expand the dependent list?

@Thenarayanaclips 2 года назад

Thanks a lot sister for your hep.

@locsxcurvesqueenflyhoneigh 4 месяца назад

This was extremely helpful. I would love to know how I can take this a step further and have the second dropdown automatically populate additional data into a 3rd cell?

@chrism9037 3 года назад

Great job Leila!

@LeilaGharani 3 года назад

Thanks Chris!

@sefam8474 3 года назад

How we apply this on entire column

@kayasami898 2 года назад

same problem here :(

@agustingavina9011 День назад

@@kayasami898 It seems she left that part for a second video, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ku17vgq4Q14.html

@agustingavina9011 День назад

It seems she left that part for a second video, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ku17vgq4Q14.html

@arcas002 3 года назад

Thank you for this. Question - So my list have instructions in the cell next to it, they are located in a separate sheet tab. I want to make a drop down on a different sheet which I know how to do it but how do yo carry the instructions for that list? Is there a way? Thanks!

@pappafritto 8 месяцев назад

thank you!

@dongohuy7066 3 года назад

That is awesome!!! Thanks so much.

@LeilaGharani 3 года назад

You are so welcome!

@idrisabismailhadjoudja2313 3 года назад

Thank You Mrs Leila for you great lesson, I have question, I need Like that list but not just for lists but one collumn or two in my table how I can doit it?

@markfrombriz 3 года назад

Another useful video from the google sheet goddess

@LeilaGharani 3 года назад

Glad you think so, Mark 😁

@chadfell7182 3 года назад

LOVED THAT

@hazelweiss11 7 месяцев назад

Thank you

@noumanbantan3772 Год назад

Thank you so much

@mohammadashiq9996 3 года назад

I like this Video its very simple thank you

@LeilaGharani 3 года назад

You are welcome 😊

@avikchowdhury3402 10 месяцев назад

Leila, your video is great! Need some help - Whenever I am copy pasting the rows the data validation does not catch the filter formulas. Can you suggest me a way out.

@liamroberts1752 4 месяца назад

Hi Leila, this is so clear, thank you very much. Does this work with an "ImportRange" Function? I am trying to build templates which will be used with my data set held in another spreadsheet altogether.

@mrw873 7 месяцев назад

Hi, First, thank you for this tutorial, it is excellent and helped me get way further in making this possible than other tutorials. However, I am still having trouble with making it happen on my reporting sheet. vs just on my masterdata sheet

@rajsahu1029 3 года назад

Very useful and interesting.

@LeilaGharani 3 года назад

Glad you liked it, Raj!

@CapeFearRiverLife Год назад

Thank You!!!

@VinayKumar-tr8be 3 года назад

Great, whether we can make dynamic dash board in Google sheet? Like power pivot in excel.

@1969mattchew 2 года назад

Leila, Thanks. This helped. I am trying to Create of users that Own a particular Boat. They select that boat from the list and it references that Data page. My issue is that i feel like i need a separate Data page for each user or the data Prep field that uses the filter is only pointing to the first user. Do you have any thoughts?

@Brroo2 Год назад

Great tool, what if I'm preparing a 600 line sheet? how can I do the multiple dependent lists for the 600 lines? will I create the (indirect) column 600 times? in excel: the (indirect) function can be written in the data validation range, but in Google Sheets it is not possible do you have an advise for that?

@slowly-but-eventually Год назад

She has a video about that! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ku17vgq4Q14.html

@davidtopp1972 3 месяца назад

Great video! I need to ask if it is possible to make your own formula work in multiple rows. I am trying to find a way to use Dependent Data Validation in my Budget Check register. I have numerous Parent Categories and Sub-Categories. Please let me know if there is a way I can accomplish this. Thank you!