Array function with multiple paramaters

I am working with a data table and I want to return multiple instances given than 2 parameters are met. My table is a list of jobs and the mechanics and paramaters attached to those jobs. I want to use the mechanic and flow day and return in an array all of the work listed for each mechanic on each flow day. Below I have listed a couple of my failed attempts.

=INDEX(Jobs!$A$2:$W$951,SMALL(IF((Jobs!$I$2:$I$951=W$1)*(Jobs!$W$2:$W$951=$B4),ROW(Jobs!$A$2:$A$951)+1,"N/A"),ROW(Jobs!2:2)))

=INDEX(Jobs!$A$2:$Z$951,SMALL(IF(Jobs!$H$2:$H$951=1,ROW(Jobs!$H$2:$H$951)),ROW(1:1))-1,1)

I used a previous thread as my baseline and that is below

=IF(ROWS($A13:$A$14)>COUNTIF($BH$3:$BH$9999,$B$9),"12",INDEX($A$3:G$9999,SMALL(IF(($BH$3:$BH$9999=$B$9)*($DA$3:$DA$9999>=$H$9)*($DA$3:$DA$9999<=$N$9),ROW($BH$3:$BH$9999)-ROW($BH$3)+1,""),ROWS($A13:$A$14))))

Column A is the result I want Jobs
Column I is the flow day
Column W is the mechanic

Any help you can provide is appreciated.

I added the below table as an example of what I am working with and want. The actual file has a lot more data but this gets the idea across.

INPUT
Job Mech Flow Day
Job 1 Joe 1
Job 2 Bob 1
Job 3 Sue 1
Job 4 Joe 1
Job 5 Bob 1
Job 6 Sue 1
Job 7 Joe 2
Job 8 Bob 2
Job 9 Sue 2
Job 10 Joe 2
Job 11 Bob 2
Job 12 Sue 2
Job 13 Joe 3 I want to use the flow day and mech names as references in the output file.
Job 14 Bob 3
Job 15 Sue 3
Job 16 Joe 3
Job 17 Bob 3
Job 18 Sue 3
Job 19 Joe 3
Job 20 Bob 3
Job 21 Sue 3



Desired Output

1 2 3
Job 1 Job 7 Job 13
Job 4 Job 10 Job 16
Job 19
Job 2 Job 8 Job 14
Job 5 Job 11 Job 17
Job 20
Job 3 Job 9 Job 15
Job 6 Job 12 Job 18
Job 21

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

I guess I have a more basic question now. Once I get the equation set up how do I make it work. I selected the whole range in the spreadsheet and ctrl+shift+enter and it shows the same result for all of the cells. When I open the file though it has equations and the brackets indicating an array. This is just a basic misunderstanding of how to set up an array on my part but if anyone could help it would be appreciated.

I am playing around with the file and can get the array to work if I do 1 cell at a time and create the array for each cell but when I try and select a range it makes all of the cells in the selection have the same equation with the same reference cells.