Match with variable lookup array

[Oras78]

Hi, I have a table in which I'm trying to do index and match match. however, I realized my second match lookup array is within in the index table. I tried to use index within the match but I'm getting an error. I know the first multiple match is working, but the second match isn't.

Any help would be appreciated

State SRC NetSRC.xlsx
	A	B	C	D	E	F
1	Column2	Column3	Column20	Column23
2					Bonus Depreciation Property - Early Disposition Subtraction - AL	Bonus Depreciation Current Year Addback
3	Jurisdiction Code	Filer Indicator	Bonus Depreciation Property - Early Disposition Subtraction - AL	Credit for Employer Differential Wage Payments Expenses
4	AL	" "	90	80	90	#N/A
5	AL	X	6	45	6	#N/A
6	AL	F	27	87	27
7	AL	R	4777	977	4777
8			982	887	982
9
10	Jurisdiction Code	Filer Indicator	Bonus Depreciation Current Year Addback	Bonus Depreciation Subtraction - Pre 2005 - Prior Year
11	AR	" "	42649	-60340
12	AR	X	17	-23
13	AR	F	0	0
14	AR	R	36	-50
15			42702	-60413
16
17	Jurisdiction Code	Filer Indicator	Bonus Depreciation Current Year Subtraction - AZ	Bonus Depreciation Subtraction - AZ
18	AZ	" "	-360754	-45701
19	AZ	X	-2968	-378
20	AZ	F	0	0
21	AZ	R	-2844	-362
22			-366566	-46441
Sheet1

Cell Formulas
Range	Formula
E2	E2	=C3
F2	F2	=C10
E4:F4	F4	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=$A4)*($B$4:$B$22=$B4),0),MATCH(F$2,$C$3:$D$3,0))
F5	F5	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=$A5)*($B$4:$B$22=$B5),0),MATCH(F$2,INDEX($C$4:$D$22,,),0))
E5:E8	E5	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=A5)*($B$4:$B$22=B5),0),MATCH(E$2,$C$3:$D$3,0))

 

[Oras78]

Hi, I have a table in which I'm trying to do index and match match. however, I realized my second match lookup array is within in the index table. I tried to use index within the match but I'm getting an error. I know the first multiple match is working, but the second match isn't.

Any help would be appreciated

State SRC NetSRC.xlsx
	A	B	C	D	E	F
1	Column2	Column3	Column20	Column23
2					Bonus Depreciation Property - Early Disposition Subtraction - AL	Bonus Depreciation Current Year Addback
3	Jurisdiction Code	Filer Indicator	Bonus Depreciation Property - Early Disposition Subtraction - AL	Credit for Employer Differential Wage Payments Expenses
4	AL	" "	90	80	90	#N/A
5	AL	X	6	45	6	#N/A
6	AL	F	27	87	27
7	AL	R	4777	977	4777
8			982	887	982
9
10	Jurisdiction Code	Filer Indicator	Bonus Depreciation Current Year Addback	Bonus Depreciation Subtraction - Pre 2005 - Prior Year
11	AR	" "	42649	-60340
12	AR	X	17	-23
13	AR	F	0	0
14	AR	R	36	-50
15			42702	-60413
16
17	Jurisdiction Code	Filer Indicator	Bonus Depreciation Current Year Subtraction - AZ	Bonus Depreciation Subtraction - AZ
18	AZ	" "	-360754	-45701
19	AZ	X	-2968	-378
20	AZ	F	0	0
21	AZ	R	-2844	-362
22			-366566	-46441
Sheet1

Cell Formulas
Range	Formula
E2	E2	=C3
F2	F2	=C10
E4:F4	F4	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=$A4)*($B$4:$B$22=$B4),0),MATCH(F$2,$C$3:$D$3,0))
F5	F5	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=$A5)*($B$4:$B$22=$B5),0),MATCH(F$2,INDEX($C$4:$D$22,,),0))
E5:E8	E5	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=A5)*($B$4:$B$22=B5),0),MATCH(E$2,$C$3:$D$3,0))

I forgot to move the above lookup reference for the fist match.

State SRC NetSRC.xlsx
	A	B	C	D	E	F
1	Column2	Column3	Column20	Column23
2					Bonus Depreciation Property - Early Disposition Subtraction - AL	Bonus Depreciation Current Year Addback
3	Jurisdiction Code	Filer Indicator	Bonus Depreciation Property - Early Disposition Subtraction - AL	Credit for Employer Differential Wage Payments Expenses
4	AL	" "	90	80	90	#N/A
5	AL	X	6	45	6	#N/A
6	AL	F	27	87	27
7	AL	R	4777	977	4777
8			982	887	982
9
10	Jurisdiction Code	Filer Indicator	Bonus Depreciation Current Year Addback	Bonus Depreciation Subtraction - Pre 2005 - Prior Year
11	AR	" "	42649	-60340
12	AR	X	17	-23
13	AR	F	0	0
14	AR	R	36	-50
15			42702	-60413
16
17	Jurisdiction Code	Filer Indicator	Bonus Depreciation Current Year Subtraction - AZ	Bonus Depreciation Subtraction - AZ
18	AZ	" "	-360754	-45701
19	AZ	X	-2968	-378
20	AZ	F	0	0
21	AZ	R	-2844	-362
22			-366566	-46441
Sheet1

Cell Formulas
Range	Formula
E2	E2	=C3
F2	F2	=C10
F4	F4	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=$A11)*($B$4:$B$22=$B11),0),MATCH(F$2,$C$3:$D$3,0))
F5	F5	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=$A11)*($B$4:$B$22=$B11),0),MATCH(F$2,INDEX($C$4:$D$22,,),0))
E4	E4	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=$A4)*($B$4:$B$22=$B4),0),MATCH(E$2,$C$3:$D$3,0))
E5:E8	E5	=INDEX($C$4:$D$22,MATCH(1,($A$4:$A$22=A5)*($B$4:$B$22=B5),0),MATCH(E$2,$C$3:$D$3,0))