Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!
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)
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.