How to use XLOOKUP to create a dependency drop-down list in Microsoft Excel
In this Microsoft Excel tutorial, I will show you how to create a dependency drop-down list using the XLOOKUP function. This can be done without a filtered list. By using data validation and XLOOKUP in the source, you can avoid having to create the list on another part of the worksheet, and you can duplicate it.