Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)
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 - https://chandoo.org/wp/how-to-create-...
Full Excel Course - https://chandoo.org/wp/excel-school-p...