Uploaded November 2024 | Updated September 2026, 2 weeks ago
👩🏻🎓 Check out my Professional Excel Productivity & Power BI courses
accessanalytic.thinkific.com
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 youtu.be/OFNDtXxrk0g
⏬ Download the file:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/Es1QX19t3ElLmyoMq_hntlwBDLD_D97_7ztOlRPVfSTqMQ?e=buxjaM
Mark’s video
youtu.be/L3jWMoE6KnI?si=b5HxJRYcZBAciU37
My previous video of “easiest dependent drop down list”
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
13:43 if you can’t rely on a sorted table
🧑🏻🎓Check out our Power BI Training Course
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
wyn.bio.link
👩🏻🎓 Check out my Professional Excel Productivity & Power BI courses
accessanalytic.thinkific.com
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 youtu.be/OFNDtXxrk0g
⏬ Download the file:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/Es1QX19t3ElLmyoMq_hntlwBDLD_D97_7ztOlRPVfSTqMQ?e=buxjaM
Mark’s video
youtu.be/L3jWMoE6KnI?si=b5HxJRYcZBAciU37
My previous video of “easiest dependent drop down list”
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
13:43 if you can’t rely on a sorted table
🧑🏻🎓Check out our Power BI Training Course
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
wyn.bio.link
