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