Dependent Drop Down Lists In Google Sheet - Excel Tip and Tricks

Discover how to create a dependent drop down list in Google sheet. In essence, how do I create a dependent drop down list in Google Sheets?

We will also look at how to do multiple criteria drop down list in Google Sheets? And how do you create a list based on criteria in Google Sheets?. Also learn how do I create a dynamic dependent drop down list?. Or how do I create multiple dependent dropdown lists? In short, how do I add a dependent Dropdown?

These are the steps outlined in my video.

Country Drop Down List
1) Select B2
2) Data ~ Data Validation
3) Add Rule
4) Criteria as "Dropdown (from a range)"
5) Select data range
6) '224'!A14:A
7) Done

State Drop Down List
1) Select B3
2) Data ~ Data Validation
3) Add Rule
4) Criteria as "Dropdown (from a range)"
5) Select data range
6) '224'!D14:D
7) Done

City Drop Down List
1) Select B4
2) Data ~ Data Validation
3) Add Rule
4) Criteria as "Dropdown (from a range)"
5) Select data range
6) '224'!E14:E
7) Done

Get Unique State
1) Select cell D14
2) =SORT(FILTER(B14:B,A14:A=B2))

Get Unique State
1) Select cell E14
2) =SORT(FILTER(C14:C,B14:B=B3))

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
How do I create a dependent drop-down list in Excel - Excel Tip and Tricks

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google

[dennis_woo]

Good stuff. A bit too fast so I had to hit paused a few times. Maybe next time link this shorts to a long form youtube video. Anyway thanks so much for this tip which was just what I was looking for.