Index array list based on multiple matching Values

Hello-

I have searched and I can't seem to figure out how to do what I am trying to do. I have a sheet with a list of values, exported from another program. I manually import that data into a sheet in my template called "Data". On the Data sheet, column A has department numbers 0-17, column B has three digit equipment numbers (001-999), Column C has letters associated with the number of each piece of equipment being used (A-F, G-H, etc), Column D has "N" or "R" for new or relocated, and Column E has a description. There are multiple instances of equipment numbers in each department.

The other sheets in the template that are numbered 0-17, for each department. I have figured out how to import all of the equipment numbers into sheets by department number, but I can't figure out how to get columns C, D, and E to import based on the exact equipment number entry in that row.

Here is what I have to import the equipment into each department sheet:
{=IF(ISERROR(INDEX(Data!$B:$B,SMALL(IF(Data!$A:$A=$B$2,ROW(Data!$A:$A)),ROW(1:1)),0)),"",INDEX(Data!$B:$B,SMALL(IF(Data!$A:$A=$B$2,ROW(Data!$A:$A)),ROW(1:1)),0))}

$B$2 is the cell where I enter the department number on each sheet.

As you can see from the images below, I have figured out how to get it to grab the quantity letter from the row that matches the Department number and Equipment number, but I can't figure out how to get it to show the next one in each series. The entries on C9:C11 on the equipment sheet should be A, B, then C, but they all show up "A". The formula that I am currently using for those cells is
{=IFERROR(INDEX(Data!$C:$C,MATCH($B$2&B9,Data!$A:$A&Data!$B:$B,0),1),0)}

Data Sheet:
Data Sheet.JPG

Department Sheet:
Department Sheet.JPG

Thank you!
Pidgeon