Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too) @chandoo_
Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)  @chandoo_
Uploaded February 2024 | Updated November 2026, 2 hours ago
Need dependent drop downs or cascading drop-downs in Excel? Use this simple but elegant approach.

This technique relies on the powerful & new XLOOKUP function.

Learn more:

Tutorial with sample workbook - chandoo.org/wp/how-to-create-dependent-drop-downs-in-excel-dynamic-multiple

Full Excel Course - chandoo.org/wp/excel-school-program
Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)The Ultimate Excel Dashboard: Visualize Data Like a ProLearn 80% of DAX in an Hour (with FREE sample file)Learn Excel COPILOT in just 15 minutes and Work Smarter ๐ŸคฏHow to make a Show / Hide SLICER PANEL in Power BI ๐Ÿ’กMake a beautiful and interactive To-Do List with Excel (Easy Tutorial ๐Ÿ‘Œ)Power BI Ecosystem - Explained in 25 minutesBecome an Excel PRO with this complete Dashboard Project ๐Ÿ“ˆYou dont need work email to use Power BI - Easy Fix ๐Ÿ˜ŽDONT tell my boss, but ChatGPT made this Excel dashboard ๐ŸคซHow to Split Names in Excel Super Fast!Calculate Employee Tenure Easily with this Formula Trick๐Ÿ’ก
Chandoo |

Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER