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: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERTMA9dpMd1JsRtAiZb7nxYBgNq3C7sx96psF_rCn3vZrw?e=5qF8ud

More Excel Function Tutorials: https://youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST