Glide Training Logo

May 2014

How to create a variable drop down list in Excel

Written by Jane Hames

Creating a variable drop down down list using Indirect

During some advanced Excel training, I was asked how to create a variable drop down list in excel using a data validation list that changes depending on the value in a related cell. The reason for the question was so that estimators entering building supplies into a data list could enter the name of the material and then select from a list of quantities that that specific material can be ordered in. Always up for a challenge, I decided to use my creativity and I found a solution through the combined use of data validation and the indirect function.

Read more on How to create a variable drop down list in Excel…