In this video, I will show you how to create multi-level drop-down lists in Excel using new Excel functions such as XLOOKUP, XMATCH, TAKE, and DROP.
I will show you how to make a simple one-level dependent dropdown list and then extend the logic to create multi-level drop-down lists easily.
👉 Download File: https://www.dropbox.com/scl/fi/0y9vh0q8mpaamm0qgie6w/Dependent-Drop-Down-in-Excel-TE.xlsx?rlkey=5sg0n2y4brygx6yxrh7912mf2&dl=1
00:00 Intro
00:18 Demo of Multi-Level Dependent Drop Down List
01:11 Single Level Dependent Drop Down List
07:14 Multiple Dependent Drop Down List
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial #SumitBansal