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.

0:00 Introduction
1:27 Data Validation
2:09 XLOOKUP filtered lists
4:20 Data Validation with a filtered list
6:19 XLOOKUP function inside Data Validation (no filtered list)
7:48 Adjusting cell reference

Practice Sheet: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERTMA9dpMd1JsRtAiZb7nxYBgNq3C7sx96psF_rCn3vZrw?e=aGj7LZ

Dependent Drop-Down Lists using the INDIRECT function: https://youtu.be/oYF162_Cmwc