Sign In


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



Create a Dynamic (changing) Drop-Down List in Excel


This video will teach you how to create a drop-down list with content that changes based on another drop-down list within excel.

The process is very simple, but the INDIRECT formula comes into play.

As a learn-as-you-go type of excel user, this formula was in no way a part of my arsenal and it took me several hours to figure this out one day at work. Hopefully this video will save you some time :-).

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.