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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.