Multi Row Dynamic Dependent Dropdown List in Google Sheets

Learn how to create a multi-row dynamic dependent dropdown list in google sheets.

Don't forget to subscribe to @xlpedia

Copyright Disclaimer:
This video may contain some copyrighted materials without specific authorization of the owner but contents used here fall under the "Fair Use" as described in The Copyright Act 2000 Law No. 28 of the year 2000 of Bangladesh under Chapter 6, Section 36, and Chapter 13 Section 72. According to that law, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statutes that might otherwise be infringing. Non-profit, educational, or personal use tips the balance in favor of fair use. "Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for -fair use- for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statutes that might otherwise be infringing. Non-profit, educational, or personal use tips the balance in favor of fair use."

#DynamicDropdownList #DropdownList #Dropdown #Sheets #DynamicDropdown #GoogleSheets

[roplusk]

just spent the whole afternoon watching videos that taught how to do the same using apps script, but this has made my life much easier and fit perfectly to what I needed. thanks!!

[hannahzain]

Hi, what if it is the other way around when your dropdown are the list of fruits and vegetables and the dependent dropdown will identify if it is a fruit or vegetable? Thanks!

[AM-jwlo]

need example with spaces between words to ensure i don't have to put a _ between.

[georgesrenson]

Hello. Thanks for that video that looks fantastic. Unfortunately, it seems that I made a (or several) mistake(s) in my formula since the spreadsheet always mentions an error. Could you please help me ? Hereunder is the formula I try to use.
There are 10 categories instead of 3 for the first dropdown list and up to 89 items in the second.
Thanks for any help from anyone. Best regards. Georges from Belgium.

=ARRAYFORMULA(IF(LEN(M2:M), TRANSPOSE(IF(TRANSPOSE(M2:M)=A1, INDIRECT("BEATBEAT"), (IF(TRANSPOSE(M2:M)=B1, INDIRECT("LIVEBAND"), (IF(TRANSPOSE(M2:M)=c1, INDIRECT("ROCK"), (IF(TRANSPOSE(M2:M)=D1, INDIRECT("DISCODANCE"), (IF(TRANSPOSE(M2:M)=E1, INDIRECT("BALLROOM"), (IF(TRANSPOSE(M2:M)=F1, INDIRECT("FIFTIESSIXTIES"), (IF(TRANSPOSE(M2:M)=G1, INDIRECT("JAZZBLUES"), (IF(TRANSPOSE(M2:M)=H1, INDIRECT("LATIN"), (IF(TRANSPOSE(M2:M)=I1, INDIRECT("BOSSASAMBA"), (IF(TRANSPOSE(M2:M)=J1,

[filipfinrasek]

That is great! Unfortunately, I have tried with 3 categories and various number of items under each category (57 items all together) and it turns out very slow for me :/
Still it is great I was able to make it work with your help! Thank you very much.

Do you have potentially any tip how to make it faster?