Index Match and multiple value matches - add next

[dsami0122]

I have a page of Data, a drop down that selects a letter category

so I am trying to pull data from one page based on the letter category I select and allow for multiple different returns as long as the selected category is the same

RAW DATA
Name Category Date of Hire
john FT 1/1/2022
Mary PT 2/1/2022
Adam IN 3/1/2022
Jan PT 4/1/2022

In a Different Page I want to have it put over all information depending on the drop down selection of "PT"

Drop Down Selection = PT

I have tried INDEX('Workload Active Data'!D:D,MATCH('13a Part 1'!$C6,'Workload Active Data'!E:E,0))

but It doesnt advance so I am getting the first hit only = Mary line 1 and Mary line 2

 

[dsami0122]

I have a page of Data, a drop down that selects a letter category

so I am trying to pull data from one page based on the letter category I select and allow for multiple different returns as long as the selected category is the same

RAW DATA
Name Category Date of Hire
john FT 1/1/2022
Mary PT 2/1/2022
Adam IN 3/1/2022
Jan PT 4/1/2022

In a Different Page I want to have it put over all information depending on the drop down selection of "PT"

Drop Down Selection = PT

I have tried INDEX('Workload Active Data'!D:D,MATCH('13a Part 1'!$C6,'Workload Active Data'!E:E,0))

but It doesnt advance so I am getting the first hit only = Mary line 1 and Mary line 2

using Microsoft® Excel® for Microsoft 365 MSO (Version 2204 Build 16.0.15128.20158) 64-bit