Google Sheets: Conditional Multi Drop Down Lists

Today we are creating a multiple drop down list where the values in the second drop down are dependent on the value selected in the first dropdown.

Have you ever been building a spreadsheet and filling out data with a few related sets and you wished there was an easier way? You're in luck -- there is! I was inspired by two other YouTubers:

 @LeilaGharani  in this video:    • Create Multiple Dependent Drop-Down L...  
 @KevinStratvert  in this video:    • Dependent Drop Down List in Excel Tut...  

I saw what they did and wanted to take it up another notch.

00:00 - intro
00:39 - formulas in this video
00:57 - XLOOKUP
01:31 - SORT
01:58 - ARRAYFORMULA
02:24 - TRANSPOSE
02:54 - let's build!
07:29 - the extra extra
15:46 - outro
---

All music is from Epidemic Sound