Google Sheets - Dependent Drop Down Lists | 2 Ways

[@LeilaGharani]

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

[@fadly1896]

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

[@deeeyv]

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

@@deeeyv i see, thank you

[@meganesguerra7540]

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]

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

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

[@akashrathore5970]

Same issue with me

[@agustingavina9011]

It seems she left that part for a second video, kzbin.info/www/bejne/oaaUaKmdppmEZ5Y

[@igyuse]

Exactly, i encountered this issue too

[@jdavis6650]

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

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

[@PeterBlood1685]

Well done. One of the best, if NOT the best, youtube demonstration I've seen in many years.

[@KarunManuja]

Simply Explained the Functionality and very easy to Understand. Very Nice!!! :)

[@arsenigold9470]

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]

Glad it was helpful.

[@TylerStanczak]

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

[@LeilaGharani]

Glad you think so!

[@juliestage9773]

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

[@huffinLeeroy]

+1 sub. Awesome, awesome work. I spent DAYS trying to find this, and all I got was over complicated scripts (and I have a reasonable comprehension of java). This is so brilliant in its simplicity!

[@LeilaGharani]

Thanks for the sub!

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

[@adrianodvo]

I believe this video will solve your problem: kzbin.info/www/bejne/oaaUaKmdppmEZ5Y

[@dew3968]

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

[@LeilaGharani]

Welcome! You're up early 😴

[@ahmedKorra1]

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

[@3KLuu]

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.

[@akbarpermanasidik4660]

Great explanation as always. clear and easy to follow. thank you very much

[@TwooPoint0]

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

[@LeilaGharani]

Glad you enjoyed it!

[@measureQuick]

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

[@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]

kzbin.info/www/bejne/oaaUaKmdppmEZ5Y&ab_channel=LeilaGharani

[@BangaliBabuVlogs]

exactly my question too

[@Kontroller100]

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!

[@Kontroller100]

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

[@mohamedzaneer3065]

Thanks Leila. wonderful explation

[@sefam8474]

How we apply this on entire column

[@kayasami898]

same problem here :(

[@agustingavina9011]

@@kayasami898 It seems she left that part for a second video, kzbin.info/www/bejne/oaaUaKmdppmEZ5Y

[@agustingavina9011]

It seems she left that part for a second video, kzbin.info/www/bejne/oaaUaKmdppmEZ5Y

[@AmarSid-u8p]

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

[@sovannetmeas]

You saved me. Thank you.

[@MillsSchmidt]

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!

[@michaeljenssen8976]

Thx for keeping everything in one sheet in this tutorial😊

[@ZaileeRamsey]

Thanks. Just what I needed.

[@CIKGUR]

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

[@vwvMARDUK]

This is awesome quality material. Thank you!

[@LeilaGharani]

Glad you enjoyed it!

[@DevanshuJain-n4n]

Thanks a lot mam 🙂🙂

[@matthewmorrisson1806]

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

[@egymade]

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]

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

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

[@rajanghadi2337]

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]

So nice of you!

[@egymade]

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

[@michaelangelo9702]

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

[@peter102]

great video. helped me with something i was stuck on

[@farshidmkhn4409]

thank you dear leila, it was so helpful

[@itsgreysbee]

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

[@DougHExcel]

Great instructions on the different ways to create this!

[@LeilaGharani]

Thanks Doug :)

[@amajidkhan1978]

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

[@Knebelcm1986]

Finally found a good video for this

[@Prankmonkey714]

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]

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

[@NastjaToolstrek]

thank you!

[@MaralSabbagh]

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

[@LeilaGharani]

Thanks for the sub!

[@nupursingh9543]

Very nicely explained

[@hegekrisz4787]

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

[@syrupsyrup335]

Exactly what I was looking for! Excellent!

[@alvicmariefrancisco5088]

thank you so much for this info!

[@learnwithsauravsharma]

You nicely explained what i needed thank u so much.

[@donjuliangonzalez9530]

Thank you!!!!!

[@mattinikcube]

I just loving you now. really what I needed

[@FarhanC84]

Waiting for the next video :)...I really need to know how to manage multiple drop down lists on different rows.

[@LeilaGharani]

Coming soon! :)

[@smartcfo2614]

@@LeilaGharani Please Please Please.

[@jobsanca]

This video for drop down on multiple lines already was published? I can't find it =/

[@checkpte8475]

excellent, you have earned a subscribition and a comment

[@akin-ojoayotomide8909]

Thank you so much for this!

[@fahrihariri746]

This is the formula that i l've been looking for 😭😭😭😭

[@derekalcorn3]

This is exactly what I was looking for. Thanks Leila

[@LeilaGharani]

You’re welcome 😊

[@faridi-bin-Zouq]

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

[@LeilaGharani]

I'm glad to hear that :)

[@gennarobasso144]

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

[@jeremyisjeremymartin]

This saved my life

[@LeilaGharani]

Happy to help :)

[@BSResumeDatabaseForum]

Thank You So Much ,

[@Blinks77]

That was excellent. Thankyou.

[@guillermotrevino4149]

Hello, Where can I find the link to the "next week's video"? Leila's video are the best! It's very easy following her video with all her examples, in just the perfect pace!

[@fayeduclayan7629]

Thanks for this! very helpful

[@IsabelExplains]

This is genius! Thank you! 🙏

[@BetterSheets]

This makes google sheets sooio much more interactive.

[@GV-gn3mj]

Thank you. How can apply the first option(filter) to an entire column, to drag the formula with the data validation

[@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! kzbin.info/www/bejne/oaaUaKmdppmEZ5Y

[@kakasantos8545]

Tem meu Jóia!!!

[@lorenvillaverde2564]

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?

[@StuMorris]

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

[@egymade]

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!

[@jnshieldpiservices4874]

Brilliant

[@justinmacrae7430]

Thank you so much!

[@noumanbantan3772]

Thank you so much

[@fahrihariri746]

Could this formula applied into multiple rows?

[@germaincharlie2277]

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

[@johnaffolder5605]

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.

[@LuxexCurves]

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?

[@RFC2014]

Thank you , short , intensive and informative

[@IslamQuranMuslim]

Thanks a lot, I tried for this.

[@NUShortFilms]

Thanks a lot sister for your hep.

[@avikchowdhury3402]

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.

[@markfrombriz]

Another useful video from the google sheet goddess

[@LeilaGharani]

Glad you think so, Mark 😁

[@02buddha02]

Leila... You are the freaking best

[@vanik9432]

Helped alot! :)

[@RajendraPatel.]

It's really awesome 😉🙏🙏

[@kristofferbrustad3296]

Hey Leila, thank you so much for the video, im havin trouble compleating the formula in teh data prep. row. After i start using the match function and try to match the dependant drop down list to the original list i get an error and it tells me "formula parse error". dont know what im doing wrong. got any tips?

[@Digitall3]

this is fantastic, thank you!

[@chrism9037]

Great job Leila!

[@LeilaGharani]

Thanks Chris!

[@CapeFearRiverLife]

Thank You!!!

[@temurkhan9601]

thank you aa looooot

[@elluchocr5596]

This is GOLD!! Helped me alot. Thanks.

[@rajsahu1029]

Very useful and interesting.

[@LeilaGharani]

Glad you liked it, Raj!

[@gabriel.valandro]

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

[@LeilaGharani]

You're very welcome!

[@mohammadashiq9996]

I like this Video its very simple thank you

[@LeilaGharani]

You are welcome 😊

[@corporatesolutions5573]

Hi Leila thanks for the video. The filter is conditioned on one single cell, on the first dropdown. I copied down the first dropdown to multiple rows, the filter does not change. It always reference the same cell.

[@MissJCAnn]

I have the same issue. How do I apply this to multiple cells?

[@AmadoSerna]

@@MissJCAnn Would love to know this as well

[@laissezfairez]

Remove the fix $ sign on the first row, then when paste, choose validation only

[@spencerwilliams3385]

@@laissezfairez Can you expand on this?

[@pancux670]

My problem is the same.

[@justinenaayaa2692]

Please Google sheets have been updated so can you help with the data validation for the new updated format

[@akhil11320]

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

[@hisstuff1973]

Do have a video showing how make a word not show after you've entered from the drop down? E.g. I have a list of names in the drop down (Mark, Jenn, Steve, Mason, Gary). I want to enter Jenn, but after show Mark, Steve, Mason, Gary left in the drop down. I hope this makes sense. Thank you.

[@bilalperouz9739]

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

[@Dipenparmar12]

Amazing thanks for your nice and neat tutorial. love it

[@AlfordLau]

thank you

[@chadfell7182]

LOVED THAT

[@aymanammar4969]

where is the next week video you mentioned about it at the end of this one ! May you provide its URL