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)