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
Department & Name	Pay Description	Amount	Deduction Description	Amount
PAY 1	TAX 1
John Smith	TAX 2
DEDUCTION 1
DEDUCTION 2
DEDUCTION 3
Deduction Total:
PAY 1	TAX 1
John Smith	PAY 2	TAX 2
Pay Total:	TAX 3
DEDUCTION 1
DEDUCTION 2
DEDUCTION 3
DEDUCTION 4
Deduction Total:

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]200[/TD]

[TD="align: right"]25.00[/TD]

[TD="align: right"]2.33[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.38[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.81[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.00[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.12[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]3.64[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]201[/TD]

[TD="align: right"]50.00[/TD]

[TD="align: right"]4.16[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]5.00[/TD]

[TD="align: right"]0.69[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]

[TD="align: right"]55.00[/TD]

[TD="align: right"]3.01[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2.48[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.00[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1.45[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1.05[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]12.84[/TD]

</tbody>

Sheet1​

Many thanks for your insights!