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/