See a much easier version in a newer video here:    • The EASIEST Excel multiple level drop...  



This is data validation at the next level.
If you have multiple rows needing data validation drop downs, and more than 1 dependent sub level to pick from then here's the technique

00:00 Intro
00:40 Illustration of the end result
01:20 The key concepts
05:25 The fancy next level bit helper columns
14:20 Flagging invalid changes
16:00 Adding new items


Link to file https://aasolutions.sharepoint.com/:f...


Link to my simpler XLOOKUP single dependent drop down video
   • XLOOKUP and easier Dependent Drop Dow...  

Link to Leila Gharani's video on multiple row single dependent drop down video
   • Create Multiple Dependent DropDown L...  




Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/