Sign In


Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!



Create 2 Dynamic Drop-Downs Dependent on the Same Source In Excel (1 to 2 relationship)


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.

Since the INDIRECT function allows you to calculate a result, then reference that result as a named range in Excel you can use it to create some pretty complex integrations in your spreadsheet.

This video was made using Screenflow by Telestream (for Mac)

Tutor Bio

Alternative Text

In real life Mike is a husband and father of 2. He also develops websites (like this one) and makes overwhelming amounts of data understandable using Excel, Numbers, Access, etc.