Index/Match for Conditional

[ipperz]

Hello,

I am looking to create an Index/Match (open to other suggestions) that would based on a specific section of cells based on a conditional match. In example below, John Smith has pay/deductions designated to Department 200 and 201.

If I'm looking for the Tax 2 amount for John Smith in Department 201, is there a way that Index/Match be specified to view only D8:E15 based match John's name and Department?

2:7 are Department 200 and 8:15 are Department 201

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1	Department & Name	Pay Description	Amount	Deduction Description	Amount
2	200	PAY 1	25.00	TAX 1	2.33
3	John Smith			TAX 2	0.38
4				DEDUCTION 1	0.81
5				DEDUCTION 2	0.00
6				DEDUCTION 3	0.12
7				Deduction Total:	3.64
8	201	PAY 1	50.00	TAX 1	4.16
9	John Smith	PAY 2	5.00	TAX 2	0.69
10		Pay Total:	55.00	TAX 3	3.01
11				DEDUCTION 1	2.48
12				DEDUCTION 2	0.00
13				DEDUCTION 3	1.45
14				DEDUCTION 4	1.05
15				Deduction Total:	12.84

<tbody>
</tbody>

Sheet1​

Many thanks for your insights!