Channel: Teacher's Tech

Category: Education

Tags: excelexcel tutorialexcel tips and tricksdata validation drop down listxlookup drop down listdata validationjamie keethow to use xlookup to create dependent drop-down lists in microsoft excelteacher's tech tutorialsmicrosoft exceldependent drop down list in excel

Description: 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: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERTMA9dpMd1JsRtAiZb7nxYBgNq3C7sx96psF_rCn3vZrw?e=aGj7LZ Dependent Drop-Down Lists using the INDIRECT function: youtu.be/oYF162_Cmwc