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










