How to Make a Dependent Drop Down List in Google Sheets

This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets

#GoogleSheets #GoogleSheetsTips #Spreadsheet

[filipfinrasek]

great video! Is there a way to "easily" or dynamically applicate it on all rows down from A11 and B11? Or is it necessary to manually change for every row? Asking because I am trying to figure out how to do it for 100+ rows not manually.

[afiqmohd]

What about the type & the year column??When I choose "Type" option, it doesn't respond at all

[Dipenparmar]

What is if dropdown depends Row by row, (A-Row contains Vegetable, B-Rows depended on A-Row)

[Dipenparmar]

Amazing thanks for your nice and neat tutorial. love it

[rumadztwal]

WOW that was so simple and straight forward. Thank you so much. I've been stuck all day

[pappafritto]

Defininely Yes! The shortest video of all, perfect explanation.

What if there are different number of rows in columns Color and Size? When programming B11 we can only once select the size of the list to be.

[donnysteinberg]

I tried this formula using "IFS..." to allow for more possibilities however I get he error "IFS has mismatched range sizes. Expected row count: 1, column count: 1. Actual row count: 9, column count: 1." What might you suggest to fix this? thanks

[kimabola]

What if I want the dropdowns in another tab? Is it possible to keep the data set in separate tab?

[Sheezzz]

This function only works for color and size. Not for the others. Why is that? Please make new video that can do that. THX

[RDB_]

I have 2 columns in data in that 79 records then how to set multiple row dependent dropdown in google sheet. Please help me