Google Sheets - Drop Down List, 2 Dependent Dropdown Lists 

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

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

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

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

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.

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

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

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

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

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

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

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

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

@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

Thank you very much for the tutorial. Very helpful!

Thank you! This was so helpful!

Amazing tutorial, very detailed as usual, thank you !

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

this is the most useful youtube channel ever

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

You are a good teacher, thanks

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

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

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

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?

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

Thank you so much this video helped a ton!!

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

Great presentation skills and teaching habits

Thank you so much!! Great tutorial!!!

Awesome. This video helps me. Thank you!

That is crazy useful - thank you!

You helped me a lot !!! Thank you

This is actually clever! Love it

Thank you! This was so helpful

Great job I like your way to do that AWESOME

Good training! Thank you!

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!

Great video...very easy to follow!

Bless your soul. This is pure genius.

thank you very much, this is answering my question

Thank you for the tutorial.

Unbelievably helpful

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

Muito bom. Você acaba de ajudar um Brasileiro :) thank you

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

Great explanation!!!!!!!!

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

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

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.

super good explained! thnks :)

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

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.

Thanks matey. Really helps

Amazing! Thank you so much!

Very useful, thank you!

It's genious! Thank you a lot!

Awesome, Thank you so much for sharing this. So much appreciated!

Great video, thanks

Harikasın. Süper!!! Thank you very very much. I like this

Thanks. That was useful

Thanks for the video.

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?

VERY HELPFUL! THANKS A LOT

Is it possible to continue this validation down the column? So that if A3 is Audi, B3 will also only show the option available for Audi?

Well done! Thanks a lot.

Hey great video! I have a question, I'm trying to do a drop-dpwn menu with dates. I want it to show Month-Year (MMM-YY) I put the format in in the list of months-years but when I set the drop down, it will show the list as "dd/mm/yyy". Can I change that somehow? The format of the date IN the drop down? Thnx!

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

Great! Thank you very much!!

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

Wow. This is very helpful. Very much what I was looking for. However, how do I go about replicating that row down till the last row? Considering that my data is a different or very row has a different manufacturer and make? Will all the formula in this tutorial hold good even then? When replicated!? A response would be greatly appreciated :)

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

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

Thank you so much!

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?

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!

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

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

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

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.

Thanks a lot sir!

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 !

I love you this is the best one

Great! Many thanks!

A big thank you!

Cool! I used OFFSET for this ( like =UNIQUE(OFFSET(J79:J82,0,MATCH(B81,J78:M78,0))) ) but this is much better and easier. Also - have you tried to make like A, B and C kind of tree dropdowns? I mean you would have here also an option for every model of the car as well that are different for each B value. As in they are the C. You get it?

thank you so much.

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

Thanks, this really useful. I have another issue though, could you please suggest a way around? I have a cell which can have possible set of values (like a dropdown option) but this cell could have multiple values among the options. It can separate the values by a comma, or other delimiter. Is there a way user can select multiple values in a cell?

Good video, well presented, thanks! How can I change 3 dropdown lists simultaneously, based on 1 dropdown?

Nice content! thanks! And if in tab "main" you have other rows with dropdown lists? It's way more common to have this scenario than just have one row with it. The way it is if you copy the validation date cells and you choose another option it won't work because you have already an information "filtered" in the "lists" tab.

thank you very much!

Excelente - Gracias.

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.

How can you make it work for a long list of rows?? When I set up another row under Toyota, the main drop down does not auto-populate to the next dependent submenu.

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?

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

I follow your instructions to the T but I get an error message when I try. I dont know why.

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!

Fantastic!