Excel Dependent Drop down list with multiple rows AND multiple levels

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

In this Video

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 my simpler XLOOKUP single dependent drop down video

https://youtu.be/5Z2OOriFxig

Link to Leila Gharani’s video on multiple row single dependent drop down video

https://youtu.be/7mo4COng7Sg