The 2nd EASIEST Excel multiple level drop down list. Newer even easier video is available in link 🔔

🔔update: if you have a version of Excel 365 updated after July 2024 then here’s an even easier approach EVEN EASIER! Dependent Drop Down Technique in UNDER 9 minutes! https://youtu.be/lxd4Pc_gMIA ———————— For those of you with older versions of Excel i also have an update to the method in this video: Easiest Multi Level Excel Drop Down List A more robust solution here https://youtu.be/BoAtpZIf_oY One-Off dependent drop down lists in data validation are relatively straightforward: here's a technique using XLOOKUP. https://youtu.be/5Z2OOriFxig !!BUT!! if you want row after row of dependent lists it needs a different approach. I've seen a lot of solutions out there that attempt to solve this, I've even done a crazy one a few months back, but this is by far the easiest technique I've come across. ⚠️ To prevent any value being typed in the dependent validation boxes you MUST UNTICK "Ignore Blanks". This in my view is a bug and will hopefully be fixed one day. 00:00 Intro 01:06 The Setup 01:50 Formula 1 =UNIQUE(tblOptions[List1]) 02:53 Formula 2 =TOROW( UNIQUE( FILTER( tblOptions[List2], tblOptions[List1]=G6, "Empty List"))) 04:50 Formula 3 =XLOOKUP(AB5, Level1Choice, Level2Result )#excel 06:14 Apply formulas to Data Validation 08:04 The Second Level List 10:36 Conditional Formatting =COUNTIFS( XLOOKUP( I7, Level2Choice, Level3Result )#, J7)=0 You can download my workbook from the bottom of my blog post here: https://accessanalytic.com.au/easiest-excel-multiple-row-dependent-drop-down-list/ ---------------------------------- Thanks to Celia Alves for the inspiration. Check out Celia's video here: https://youtu.be/v6eT4JlKbS4 ---------------------------------- Thanks to Erik Oehm for trying to inspire me with Lambdas ( I'll get there one day! 😁 ) Here's Erik's elegant Lambda based solution (m https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EtWy-M7ET3NMpQOuZVPKq90BbaXq-ij3dVgPbFBGlEDYBg?e=bbZHLV Check out his new YouTube channel https://www.youtube.com/@excelrobot ---------------------------------- The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/ 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/