Google Sheets - Drop Down List, 2 Dependent Dropdown Lists

Learn how to make dependent dropdown data validation lists and have different dropdown values based on another cell.

[billparsons]

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

[cortega]

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

[lovermaxwell]

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

[telorceplok]

this is the most useful youtube channel ever

[thesheetsguy]

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

[omarkhaled]

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?

[justfly]

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

[kinematicspt]

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

[transparent]

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.

[gsuiteetmat]

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

[greggroos]

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

[menzoberranzam]

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

[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 <3

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

[HassanAlmaateeq]

Great presentation skills and teaching habits

[xpo]

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

[SRDFTM]

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

[thuytram]

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

[Red-fgqr]

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

[karlsickafus]

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