Google Sheets - Drop Down List, 2 Dependent Dropdown Lists

[@billparsons7732]

Perfect, no music, clear speaking and intelligent! Click here to send him a new BMW

[@telorceplok8812]

this is the most useful youtube channel ever

[@lovermaxwell1343]

the best video to show the easiest way to set Downlist as so far, no need any edit any sourcecode.

[@kinematicspt]

Wish I found this back in 2017! Thanks for putting it together!

[@realOjive]

@7:40 MY MAN! Thinking ahead and creating solutions for upscaleability (if there is such a word). Great tutorial and I am VERY grateful for it. Thank you

[@justfly2525]

INDIRECT: Awesome, I've needed that function so many times!

[@cortega26]

Works perfect for row 2, but what if I need data validation for multiple rows?

[@Lola.Owlace]

kzbin.info/www/bejne/qV6saY1qo7l3l80

[@extremegaming8718]

Is this answered

[@xpo274]

Can the data validation extend to more rows? Row 3, column B is pulling from what I input in row 2 column A.

[@aimeo.saladaga2505]

same question here, hope to get an answer.

[@Dangerica4you]

@@aimeo.saladaga2505 check link below, maybe it will help

[@HassanAlmaateeq]

Great presentation skills and teaching habits

[@thesheetsguy4478]

Great tip about leaving room in your range to add items in the future since blanks won't be included in the drop down.

[@thuytram9414]

thank you very much, very easy to understand, you are a very good teacher. many thanks

[@mindhive625]

Unbelievably helpful

[@alistairgene]

Thank you very much for this video! One question though - what if you need to name the range with a name that has spaces in it, like say the name of a US State like "New York?" 'Cause mine says invalid name.

[@ecojarzinc]

I'm having the same issue. I can't put spaces or punctuation in the Named range. I haven't figured out how to get around this. The example in the video he is only using single words, but I have much more complex names in my spreadsheet!

[@Red-fg9qr]

Ages later, this is still helpful! ty needed something like this.

[@SteveInGeorgia]

Works great for one row. But what if you have a list of people, say karate students, each with a pull-down for rank (beg, int, adv, black) and a contingent weight division indirectly linked to rank (light, light-middle, middle, middle-heavy, heavy). Do I have to construct this for every student? I tried using the indirect function in the data validation window and I get an error.

[@omarkhaled390]

In excel we can do it easily, if I have a column full of drop down how to do it ? In excel we enter it (Indirect formula) directly in data validation bar, how to do the same in google docs?

[@igorandrade8531]

Do you how to? I'm facing this issue rn

[@aldrianraffiwicaksono2269]

This is actually clever! Love it

[@gsuiteetmat6300]

I have often use indirect, this is a really powerful function. Nice content !

[@karlsickafus2027]

Excellent presentation. Did a lot of pausing and rewinding. But, finally mastered the concept. Works perfect!

[@apk29]

Love your videos, they have helped me figured out so much! Thank you!

[@menzoberranzam]

It can get quite complex, but it's very useful, and your tutorial was great. Thank you.

[@kayitonder1405]

Impressive. The tutorial is very easy to understand. Thank you.

[@greggroos4105]

Excellent, echoing Mr. Parsons, you have that knack for speaking off the cuff with very few errors. Could you bottle that ? You could retire! I had no inkling that I could make a validation range from a ROW, I've always assumed COL only. Video would have been worth it just for that

[@jacobmason7947]

Just what i was looking for straight to the point, would give two thumbs up if i could thanks

[@SRDFTM]

Try this with FILTER function, when you understand how to do it you'll absolutely love it)) Thanks for the video

[@interrecipes6822]

Wonderful. Is it possible to extend to more than two independent drop down lists?

[@deepakagarwal6014]

I need help about these validation, what I do if I need that dependent validation for next few column also?

[@nadirgirl]

This is exactly what I am looking for too. Were you ever able to solve this?

[@berendotto]

I am also in need of this feature. In excel no problem... Any luck?

[@deepakagarwal6014]

No, I still did not found solution for this except script based macro 😞

[@teacher_subs]

I think you need to learn about arrayformula method and filter function. Filter(array,criteria) If you need 3 level. That means, the first input you chose will be the criteria for the second input. The second input will be criteria for the third input. And so on.

[@Jpsans98]

OMG this is what i need!! Thank you sm !!

[@crokis372]

Amazing!! Just what i was looking for. Thanks for sharing!

[@ExcelGoogleSheets]

Great to hear!

[@malikastar9265]

Amazing tutorial, very detailed as usual, thank you !

[@ushakarkeerthi5077]

Thank you very much. I got what I expected. Keep posting

[@lidonevita]

super good explained! thnks :)

[@gaberiley1531]

Bless your soul. This is pure genius.

[@lubnashaikh8232]

This is great! Very detailed explanation of the concept. Thank you :)

[@memh314]

Great video...very easy to follow!

[@transparent91]

Amazing tutorial thank you. Just took a workload off one's shoulder with these nifty tips. I especially liked the "define named range". While struggling to get a function to work, it's really tedious having to mark up the ranges again and again.

[@FarahNazifa]

Thank you so much. This video helped me change the names everywhere but it worked. Thanks.

[@anpopochava]

thanks a lot!!!!!!, know... how do I do the same fo multiple rows in the " main " tab?

[@janeo14]

WONDERFUL CHANNEL! i wish i saw this earlier. do you have a video explain in short the differenct formulas? (example IF is.... SUMIF is.... IMPORT ..LINKING... QUERY ) trying to go thru all your videos to see what is relevant for my work needs. thank you again for teaching !

[@DimitarSavov87]

Very nice tutorials! I've learned so much from you! But I have a question if you don't mind: If you continue down the A column with brands, how can you make the dropdown in B column continue down as well and be dynamic as it is in the video? I mean, lets say A3 is BMW, A4 is Audi, etc. how can the B3, B4 update as well and all this to continue down the columns? Thanks!

[@Sankofa906]

?

[@smaccsi]

@@Sankofa906 what do you not get ? he just wants to have more dynamic dropdowns beneath the first one

[@Thetaleswithin]

That's really an awesome tutorial, brother. Thanks a lot for sharing this with us.

[@jimeva7363]

Very cool. But, I would like to be able to have the dynamic lookup for an entire column. This works great if you are only doing it for 1 cell. I want to have two columns where the values for cells in the first column determine the choices for the values in the second column.

[@praveenkumarlk8527]

hi did you got answer for this..? same doubt for me also

[@ariefmdnor5201]

Thanks sir...your video gave me inspiration. Finally this is the code I wanted: =FLATTEN (INDIRECT (F12),"") A cell referenced to a dropdown which is inside the dropdown is my ranged name. But I want convert it from horizontal to vertical. So I use FLATTEN funtion.

[@manojthapavmsrspecialistup2732]

Thank you! This was so helpful!

[@thaocao3563]

This is so amazing! Thank you for sharing!!!!

[@ExcelGoogleSheets]

Glad you enjoyed it!

[@thaocao3563]

@@ExcelGoogleSheets If I want to create a series of such dependent dropdown lists like this, how can I do it? I can not drag it like usual right? What should I do? Can you show me how?

[@techeng13]

You are a good teacher, thanks

[@jufrensiusbarasa6870]

Awesome. This video helps me. Thank you!

[@sidselpedersen6635]

That is crazy useful - thank you!

[@yourvirtualhelpbiz]

Now I can sleep! 😂 Very well taught. Thank you!

[@ahamedjameel8480]

This is one of the coolest things I know in Excel.

[@toucanyuval]

How do i apply it to the rest of the cells on the main column?

[@fabiano-co]

Did you figure out this?

[@jenniraeventling3470]

This was so helpful thank you! Could you direct me to a way to duplicate the function of the cells drop-down lists to multiple cells? or do they need to be done individual rows as show above?

[@dzilen]

I guess the author does not know how!!! without this function his advice is not very helpful

[@ruzaqir354]

Many Thx for the knowledge man u deserve more views and sub.. sadly alot of ppl love to watch compilation tiktok videos. Keep doing this man

[@rajakaz4075]

Great! Thank you very much!!

[@justwalkingwithme]

thank you very much, this is answering my question

[@General_DDay]

Great video, but is there a way for a user to add to a list from the dropdown list. For example if the user wanted to add a new make of car, say Ford, the user can just type it in from the dropdown list and it will be added to the list?

[@GV-gn3mj]

Very useful, thank you!

[@pedroramirez9254]

Thanks. Very helpful. How to do the same dropdown list several times in the same google sheet? Thanks.

[@militer3675]

Now make second similar row

[@DanEMO592]

Amazing! Thank you so much!

[@asefTutorials]

Great job I like your way to do that AWESOME

[@jayeshchaudhari593]

How I can do it for all lines in column, I tried this way and its always provide options from first cell. Like if BMW in first row and Toyota in second, still on second row I am getting BMW models

[@dieulinhauthi357]

Same qs

[@nikolasdimopoulos5711]

Hi there, very helpful video. Is there anyway you can do the indirect function for multiple cells simultaneously or you can do it only one by one? thanks anyway

[@bobykumar3960]

thank you so much.

[@brianmwevi4344]

Thank you very much for the tutorial. Very helpful!

[@yukyuk45]

Thank You! That's a great explanation! Do You have any suggestions how to get "Model" selection blank immediately if the "Make" is changed? Like in 14:16 on video if BMW is changed to Toyota and M3 is not a valid model anymore. What are the ways to clear that model cell automatically? Thank You in advance!

[@ExcelGoogleSheets]

Script.

[@jordanjc2442]

You helped me a lot !!! Thank you

[@shane673]

After you select the model, would you be able to populate some cells to the right to display packages available, without them being in a drop-down? So after you choose Toyota and Corolla, could you (to the right) display: [L] [LE] [SE] etc? Brackets denote a separate cell.

[@lukebiernbaum]

Thank you so much this video helped a ton!!

[@GOLDENPUNJABMSPEW]

And what can we do for multiple rows with same drop down button like for countery and then district

[@acrykhus]

is it possible to eliminate an option from a dropdown after it is selected, I have several drop down lists, and I want to make sure I can't select the same item multiple times from a single list.

[@md.sibgatulla842]

I love you this is the best one

[@uqbaabuhusaina5939]

Hey every thing is good but should we do this to each cell for data validation, if we need this kind of dropdown list in whole sheet?

[@hernanjorgewagner]

Thank you so much!! Great tutorial!!!

[@shanedelacruz3827]

Hi This is great! but if we need to use data validation for multiple rows and reference is only from one row?

[@petrakmetova9595]

and how to copy those drop-down cell also for the whole row?

[@karenyenvn]

Good training! Thank you!

[@sopanshirdhonkar969]

what you in Main you have multiple entries of Make. e.g. A2- Toyota, A3-Mercedece , then in lists sheet do i need to duplicate that dynamic generated values. i wanted to create an expense tracker with expense category and subcategory. although on google sheet not able to use INDIRECT function in the datavalidation LIST, it works on MS excel. e.g. in data validation list range =INDIRECT(D2)

[@ralphfernansantos4443]

VERY HELPFUL! THANKS A LOT

[@ozgurugur7609]

Great video, thanks

[@cpacpa1997]

A big thank you!

[@stefanborg7357]

Nice one! But how about if you put Aston Martin in as a Make? Named Ranges doesn't allow spaces if I'm not misstaken. Is there a workaround for that scenario? I know this is an old video so I can only hope for an answer to this. Couldn't figure it out my self unfortunately.

[@gokuldharan9233]

Only way is to separate it with an underscore..so your column header will be Aston_Martin

[@nicholasazoya1556]

Thank you for the tutorial.

[@learnspreadsheets]

Can this be done using a FILTER function? So that its more dynamic & doesnt need named ranges?

[@tracyselena]

How do you deal with this if the car brand was 2 words? Because the named ranges cannot have spaces and I want the dropdowns to have proper spacing. For example Alfa Romeo...how would that work?

[@onestoptechnocommercial5494]

Brilliant, can we get the copy of the appscript from where we can copy it

[@Den-Geist-Befreien]

Thank you! I've seen it done is with array formula function, but this seems to be more readable. Not as intuitive as Excel, but awesome either way!

[@wayneODC]

Fantastic, I’d really like to take it a step further and have another column that was colour. But the name range seem to conflict. Can you advise on this please

[@Etrehumain123]

8:43 Would (C1:1) work here for infinite row 1 data?

[@ExcelGoogleSheets]

It shoild

[@ArkadiuszLech]

So if you want to add another colummn for new brand do you have to define new range for that brand. Is it any way to deffine range automaticly or to use indirect function without deffining range. If so how to make it?

[@pelageyainna3108]

Thank you sooo much, you safe my " ass" .....I just fixed my old Table which I completely forget how to arrange.

[@minddrift7152]

Everything was going excellent until @11:49. You said "let me close this" then all of a sudden the sheets tab has a copied list of Toyota somehow. When I do it it says REF!

[@SaretGnasoh]

wonder if you know for multiple dropdown list

[@vincentpaltep1080]

Thanks matey. Really helps

[@game-party-evening]

Hi! Thanks for your detailed explanation ;) But don't you know how to make the same for 10 rows with the selection? For instance, if we have to choose 10 cars and models in the spreadsheet? Thanks in advance!

[@ExcelGoogleSheets]

You'll have to use a script. I have multiple videos on the channel. Search "dependent drop down column"

[@shootakilla27]

How do you add that to multiple cells? If I want to add multiple makes per say

[@giottogiannandrea303]

There is any way to copy the sheet with the indirect drop downs cells into a new spreadsheet?

[@kytran6657]

Is there a way to do the dropdown on every row? which will depend on the value beside it. For example column A will hold the first dropdown and B dropdown will depend on column A.

[@selvam2673]

Zoho Sheet provides formula-based Data Validation, so the little list you had to create on the side is redundant. The process becomes even simpler!

[@merlin3717]

im wanting to do something similar but i want to use data from 3 seperate drop down menus to get the final drop down menu (eg, car make, model to get the data of what extras tyou can get for that particular model) is there any way to do it on google sheets?