Excel
Feb 7, 2023 9:00 AM
Excel Dependent Drop down list with multiple rows AND multiple levels
by HubSite 365 about Wyn Hopkins [MVP]
Microsoft MVP | Author | Speaker | Power BI & Excel Developer & Instructor | Power Query & XLOOKUP | Purpose: Making life easier for people & improving the quality of information for decision makers
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
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
Link to Leila Gharani’s video on multiple row single dependent drop down video
HubSite 365 Apps