How to Create 2 Dependent Drop-Down Lists With 1 to 2 Relationship in Excel

This lesson will explain how to use the INDIRECT function and the VLOOKUP function to create two dependent drop down lists that have different information, but that both change based on a master drop down list in Microsoft Excel.\r
\r
This video was created using Screenflow by Telestream - \r
\r
Forum for Virajs question: \r
\r
Multiple selections with VBA & Data Validation: \r
\r
Amazon Affiliate link to Excel 2016 For Dummies (Excel for Dummies)\r