Index array list based on multiple matching Values

Follow up question: The previous formula worked perfectly for what I needed. Now I am trying to pull in more information in a similar way, but I can't figure out how to modify the formula to get it to work. I had it working for a minute, but then it would stop importing information after the first 4 rows.

My goal is to have each of the department sheets autofill columns K:AH from "Master" columns H:AE, based off of the equipment# (B), then Model description (G). It may not seem obvious why I need to do this because I have simplified the information in the sheets. Normally there are multiple equipment specs for each equipment number, so I need to filter the results to get the correct specs.

The Dept_0 and Dept_1 sheets have the formula I tried to use. The Goal sheet has (more or less) what I am trying to achieve. The columns that I need to filter by are in pink and the columns I need to fill are under the blue header.

Thank you!