Channel: Teacher's Tech

Category: Education

Tags: drop down list in excel with multiple selectionsdata validation listdata validationjamie keetindirect function exceldata validation in exceldrop down listquickly create a multiple dependent drop-down lists in microsoft excelteacher's tech tutorialsnamed ranges in exceldependent drop down list in excelexcelexcel data validationmultiple dependent drop-down list in excelmicrosoft excel tutorial for beginners

Description: In this video tutorial, I will show you how to create multiple dependent drop-down lists in Microsoft Excel. Using data validation and the INDIRECT function in Microsoft Excel allows you to create drop-down lists from named ranges. This makes a simple and quick way to make a dependent drop-down list but it’s not without limitations. I will go over these issues and explain why you may not want to use this method for dependent drop-down lists. Excel Practice Sheet: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERTMA9dpMd1JsRtAiZb7nxYBgNq3C7sx96psF_rCn3vZrw?e=5qF8ud More Excel Function Tutorials: youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST