Google Sheets Data Validation Dynamic Dropdown Down a Column that changes based on another dropdown 

At this point, I've practically seen every single video on a multi-row dependent drop-down list, but this is the easiest and fastest way to do it. You, my friend, are a life saver!

I've been looking for a solution for days and this tutorial saved me!! Thank you! This wasn't the first video I saw that used the transpose thing but you explained it much better.

Now I can impress my boss! 😆

Succinctly explained, i've looked for a simple solution to this for a while and this one is by far the best. Thank you!

For a long, I am searching for this solution and tried many videos, to do the same, but could not get success. As most of the tutorials are not so clear. But this is very easy and simple to understand. I really appreciate your efforts to make this tutorial simple to understand. Thank you very much and keep it up.

This is what I was looking for so many days. Thanks a lot for the this video.

Very helpful. Thank you so much! 🥰 I subscribed to your channel because of this. 😊

Thank you, this helped me a lot!

Awesome! super simple example thanks!

Wonderful :-) ! Such a helpful video. many thanks!

PERFECT!!! Thank you!

Thanks. such a knowledgeable things you tell.

Informative!

Thank you for this!

THANK YOU THANK YOU THANK YOU

Thank you for this, well explained

Pure gold, Thanks for share

Thank you, bro!!! Helped a lot

You are a beautiful human bei ng thank you soooo much. Just made life so much easier for me!!!

This was very helpful. Thank you

thanks so much!!! very useful

You are such a life saviour for me😘😘. I am going to subscribe you now.

Superb! It really works for me to create 2 dependencies drop down. Thanks

Help me me a lot thank you!!!

Heartily Thanks ❤

Thanku 😊 so much sir ❤️

life saver...many thank

Thank you ,. you have saved me !

You are only solution for for this Thanks👍👍👍

Very helpful tutorial. One thing that your video did not discuss though is that on your "Notes" tab column E has to be copied (I did past 100 to test). It will show blank (as discussed) until information is put into your "Main" tab (such as A60). Then the information on your "Notes" tab will have info.

Thanks a lot. This is what Exactly I Want.....

Hi there, just want to thank you for the video! I have a very similar setup I'm trying to implement in our Wholesale Order sheet. Currently everything works, except for when an order is complete and it's time to remove it from the list; the only way I've found that doesn't break the dynamic dropdown is to copy ALL the data beneath the 'obsolete' order, paste it on top of the old order, and then manually remove whatever was left at the bottom that is now duplicate. Is there a way to delete rows mid-sheet without wreaking havoc on the cell references? I'm not actually using FILTER, just ArrayFormula, TRANSPOSE and a whole lot of nested IF statements (I modified from another tutorial I'd found). Is there a way to use Scripts instead to, on delete of a row, force the dynamic data validation references to shift up relatively?

Im doing a yearly production record. I can (and have) made a dependent drop down with the first column representing our brands and the second representing individual products that brand offers. Im trying to make each months production (aka one sheet) have the dependent drop downs. Does that mean i need to create a cell reference for each sheet?! Or is there a way to have the dependent drop downs show on each sheet with just the one "master" set of cell references? Im also aware this may be an app script thing but im hoping not...

Really made it simple and easy to understand. Only one thing I would like to know is if I have selected value from drop down in B2 and then I change the value of A2, it shows invalid cell but does not clear it. Is there any way to clear the cell as I am using the combination of 2 values to get final result. Be my lifesaver too ;)

How about if if you add a separete options for one-A and so on?

Thank you so much for this amazing tutorial, very helpful! Just wondering if I can apply the same formula to the next column. E.g. After I select the cell on column B from the drop down list, then on column C, it will appear another filtered drop down list.

Love the video and how you explain everything. Maybe I missed this. on my main tab - I have category (A) and subcategory (B). I can drag the categories all the way down.. no problem. but can't get the subcategories to populate all the way down the page. Any thoughts. Thank you.

I am yet to find out how to make a entry row that gets the information put in first six cells postponed one or two rows below as soon as I change the status of the cell six of that first row. The idea is to keep the most recent data on top automatically and keep using first row as a data entry row. Not sure if it can be done

How do you maintain the integrity of choices when you sort your Option 1 column? (Or sort all your data by a different column)? All the validation doesn't stay aligned when the data is sorted.

Nice tutorial. Cant i add another layer of selection using same method? Lets say one-A-1 based on your example

I have a question. I am trying to make multiple dropdowns of the same list of items, but I want that list to exhaust itself after all the dropdown options have been chosen. Here's what I mean: I have 4 dropdown lists containing 4 options each. In dropdown list #1, I have options A, B, C, and D In dropdown #1, if I select option D, dropdown #2 will exclude option D; only options A to C will be available. Now, in dropdown 2, if I select option A, dropdown #3 will only contain options B and C. That's what I am trying to do. So how do I perform this set of operations? If I continue on with that pattern and select option C, then dropdown #4 will only have one available option which is B. For clarity, the reason A, C, and D are not available in dropdown #4 is because they were already selected in dropdowns #1, #2, and #3. Thank you for your time.

Question... Is it possible: I am doing a stock sheet, Names of companys are in cell A, ticker in B. The Following 170 cells are company data. I have made a droppdown menu choosing ticker and the company names, ticker ect comes opp to a bigger window with the current 12 month graph. This info is from googlefinance. BUT i would love to have like: PS, PB and other numbers popping up to that i can not get from google finance. Like i want Teslas P/B, Tesla is on line A27, ticker on B27 and say PB on X27. Is there a way to say if ticker is TSLA get infro from ""=X27?

When using filter by A-Z or Z-A, how to solve the non dynamic range problem in the data validation ? Thanks!

Hi, At 12:20, when you're showing us how to "Select a Data Range", you drag out to column 'M'. Got it. Eezy Peezy. But what if I have a dropdown that's big? Like, really big. Like, 100 options. Is there a max in google sheets on just how far to the right I can go? I tried going up to 'DD', but google yelled at me. Anybody?

Hello! I am making a spreadsheet kind of like the one that you are doing in the video except mine is for dog shows and the groups that the breeds are in for the dog shows, like for example there is a Herding group and there are 31 breeds in that group and I need to make a drop-down list so when I select the group Herding in Column A the drop-down list in column B will be all the breeds in that Group, The way that I have it set up currently is that I have Group in A1 and Breed in B1, From A3-A33 I did a data Validation with Item list with the names of the 7 groups as choices in the drop-down list, Now I need to do the same in Column B3:B33 to where when I select let's say Working Group in Column A3 and I go to the drop-down list in Column B3 I would like it to change to the breed list for that specific group. Kind of like when you go on a car dealership's website and select the make say like Chrysler and when you click Model it has all the models made by Chrysler so on and so forth. Thank you for your help in advance.

Now there is a Edit Button in drop down list which is creating problem to Owner. If owner creates certain options in dropdown and share it with other to fill the information just by selection. But EDIT BUTTON allow editors to edit the dropdown list. any suggestions

Can you only attach one range or multiple?

If you insert or move rows in your main sheet, it causes problems. Do you have a way to fix this?

Can anyone tell me how to copy a data validation column across infinite columns that go in the direction of the right of the page?

I need to create dynamic dropdown list for thousands of cells, this solution is not good enough :(

1