All Content
Timespan
explore our new search
Excel Dependent Drop down list with multiple rows AND multiple levels
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

Pro UserExcelM365 Hot News

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

https://youtu.be/5Z2OOriFxig

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

https://youtu.be/7mo4COng7Sg