Index Match Formula Needed

[Russell1745]

Hi, I'm trying to create an Index match Array formula to return the "Price" (Column H) based on matching the criteria in Column B, Column C and within the ranges of Columns D/E and F/F.
I've tried

, but this does not work. Any help would be appreciated. Thanks

New Calculator.xlsx
	B	C	D	E	F	G	H
336	Grade	Color-1	Gauge	Gauge	Qty	Qty	Price
337	BFVCHXX	035	0.00600	0.00690	0	1999	1.000
338	BFVCHXX	035	0.00600	0.00690	2000	4999	1.100
339	BFVCHXX	035	0.00600	0.00690	5000	9999	1.200
340	BFVCHXX	035	0.00600	0.00690	10000	40000	1.300
341	BFVCHXX	035	0.00700	0.00900	0	1999	1.120
342	BFVCHXX	035	0.00700	0.00900	2000	4999	1.190
343	BFVCHXX	035	0.00700	0.00900	5000	9999	1.000
344	BFVCHXX	035	0.00700	0.00900	10000	40000	1.170
345	BFVCHXX	035	0.00910	0.01100	0	1999	0.990
346	BFVCHXX	035	0.00910	0.01100	2000	4999	1.010
347	BFVCHXX	035	0.00910	0.01100	5000	9999	1.020
348	BFVCHXX	035	0.00910	0.01100	10000	40000	1.030
349	BFVCHXX	035	0.01110	0.01300	0	1999	0.660
350	BFVCHXX	035	0.01110	0.01300	2000	4999	1.000
351	BFVCHXX	035	0.01110	0.01300	5000	9999	1.250
352	BFVCHXX	035	0.01110	0.01300	10000	40000	1.400
Price Matrix

 

[Russell1745]

Thanks

New Calculator.xlsx
	B	C	D	E	F	G	H	I	J
1	Grade	Color-1	Gauge	Gauge	Qty	Qty	Price
2	BFVCHXX	035	0.00600	0.00690	0	1999	1.000
3	BFVCHXX	035	0.00600	0.00690	2000	4999	1.100
4	BFVCHXX	035	0.00600	0.00690	5000	9999	1.200
5	BFVCHXX	035	0.00600	0.00690	10000	40000	1.300
6	BFVCHXX	035	0.00700	0.00900	0	1999	1.120	Price	1
7	BFVCHXX	035	0.00700	0.00900	2000	4999	1.190	Gauge	0.006
8	BFVCHXX	035	0.00700	0.00900	5000	9999	1.000	Weight	2200
9	BFVCHXX	035	0.00700	0.00900	10000	40000	1.170	Color	035
10	BFVCHXX	035	0.00910	0.01100	0	1999	0.990	Grade	BFVCHXX
11	BFVCHXX	035	0.00910	0.01100	2000	4999	1.010
12	BFVCHXX	035	0.00910	0.01100	5000	9999	1.020
13	BFVCHXX	035	0.00910	0.01100	10000	40000	1.030
14	BFVCHXX	035	0.01110	0.01300	0	1999	0.660
15	BFVCHXX	035	0.01110	0.01300	2000	4999	1.000
16	BFVCHXX	035	0.01110	0.01300	5000	9999	1.250
17	BFVCHXX	035	0.01110	0.01300	10000	40000	1.400
Sheet1

Cell Formulas
Range	Formula
J6	J6	=FILTER(H2:H17,(B2:B17=J10)*(C2:C17=J9)*(J7>=D2:D17)*(J7<=E2:E17)*(J8>=F2:F17)*(J8<=G2:G17))

 

[Fluff]

Thanks for that. I get 1.1 with those criteria, make sure that J6 is formatted as a number with 2 decimal places

 

[Russell1745]

Thanks for that. I get 1.1 with those criteria, make sure that J6 is formatted as a number with 2 decimal places

That's pretty embarrassing.
Thank you so much, I was so vexed by this. I really appreciate it!

 

[Fluff]

You're welcome & thanks for the feedback.