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 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/