+ Reply to Thread
Results 1 to 2 of 2

Creating multiple drop-downs based on primary drop-down selected

  1. #1
    Registered User
    Join Date
    09-05-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2016
    Posts
    37

    Creating multiple drop-downs based on primary drop-down selected

    Hello everyone

    I am creating a template worksheet that is planning to be used for recording fieldwork. The person would select a "System Category" from a drop-down of available categories. Depending on the sequence number/sequence description, the person would select the appropriate "Test Category". Based on the "System Category," the "Test Category" would only show the valid test categories associated with a particular "System Category."

    While I would like to use a "drop-down" box, that could be for separate discussion

    In my sample workbook in worksheet "System_Template", I successfully created a drop-down selection for the "System Category." However, I'm struggling on how to create the "Test Category" drop-down selection.

    In the worksheet "List", I have already created the basis for getting the information for each "System Category" using the "FILTER" function.

    Is this the right path? What would be the next step?

    Thank you for your help.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,092

    Re: Creating multiple drop-downs based on primary drop-down selected

    Try the following as the source for the data validation drop downs: =OFFSET('Methods List'!$B$4,MATCH(B$1,'Methods List'!$B:$B,0)-4,1,COUNTIF('Methods List'!$B:$B,B$1))
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1