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.

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

Sorry, rookie mistake. This formula works.

Thank you for your help