How to use XLOOKUP to Create Dependent Drop-Down Lists in Microsoft Excel

Microsoft Excel Tips and Tricks

In this Microsoft Excel tutorial, I will show you how to create dependent drop-down lists using the XLOOKUP function. This can be done without having a filtered list. Using Data validation and the XLOOKUP in the source you can avoid having to create a list on another part of your sheet and you can copy it down.

Credit Teacher’s Tech