THE Easiest Multi Level Drop Down List ( easy Double XLOOKUP technique )

An awesome simple explanation of HOW TO BUILD a robust multi row dependent drop down list in Excel

I realised after recording that Mark suggested this exact solution at the start of our UNPIVOT podcast and I didn't realise until listening back to the podcast a few days later.

Hear the discussion https://youtu.be/OFNDtXxrk0g

⏬ Download the file:
https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/Es1QX19t3ElLmyoMq_hntlwBDLD_D97_7ztOlRPVfSTqMQ?e=buxjaM

Mark’s video
https://youtu.be/L3jWMoE6KnI?si=b5HxJRYcZBAciU37


My previous video of “easiest dependent drop down list”
https://youtu.be/U3WnM2JCrVc?si=ldYgW3oatoJt-0to



00:00 the aim
00:48 table set up
02:13 range name set up
04:00 the magic XLOOKUP : XLOOKUP
09:00 conditional formatting to flag invalid choices
11:12 if you can’t rely on a sorted table



🧑🏻‍🎓Check out our Power BI Training Course
https://accessanalytic.thinkific.com/


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/