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 the second criteria.  Goal is that person entering the data could choose the state from the first drop down list and then the second drop down would show only those customers in that state.

 

 

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    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:

     

     

     

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    Patricia-

     

    Just wanted to follow up and see if you were able to resolve your issue with the information I provided?

Resources