Forum Discussion

Patricia Buel's avatar
Patricia Buel
Copper Contributor
May 21, 2018

Autofill or Dropdown based on a filter

I have a set of customer data that has grown too long.  Had it as a single drop down but want to limit the drop down selection based on a second criteria,  For example purposes, let's use state as th...
BI & Data Analysis
excel
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 21, 2018

Please reference the attached sample workbook.  It will give you two examples of how to create a list linked to criteria.  Here is a good tutorial on how to accomplish the task.  You basically need to make a dropdown that points to the other dropdowns using the Indirect() Function and a number of Named Ranges:

 

http://www.contextures.com/xlDataVal02.html

 

Here is an example based on your description:

 

 

 

Resources