+ Reply to Thread
Results 1 to 6 of 6

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
    Office 365
    Posts
    99

    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 2019
    Posts
    14,058

    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.

  3. #3
    Registered User
    Join Date
    09-05-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    99

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

    Hello

    Your method lists all of the test methods. However, I only want the dropdown to show tests that are based on a selected category. In my sample workbook I chose "Category4". Therefore, I would like to show in my secondary dropdown tests that are only from Category4. These are also listed in the "Lists" worksheet.

    Thanks

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,058

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

    On the Lists sheet all tests (1:12) are listed for Category4, try changing cell B1 on the System_Template sheet to Category2.
    Let us know if you have any questions.

  5. #5
    Registered User
    Join Date
    09-05-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    99

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

    Sorry, rookie mistake. This formula works.

    Thank you for your help

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,058

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

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change the drop down values, based on selection in other columns(drop downs)
    By zeebee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2017, 01:16 PM
  2. [SOLVED] Help in creating multiple dependant drop downs
    By ahm3d in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-04-2016, 07:49 AM
  3. [SOLVED] Creating a chart from multiple drop downs.
    By KenFisher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2014, 01:48 PM
  4. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  5. Creating multiple Drop downs menus that are variable
    By Arnoldtp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2012, 09:20 AM
  6. Replies: 3
    Last Post: 10-25-2011, 03:10 PM
  7. Auto-update initial drop-down selection based on previous drop-downs
    By thornomad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 09:55 AM

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