INDEX MATCH Formula help

[looking2excel]

I'm working to get an index match formula to find a value in one table based on criteria in another. An example of each table is below, with my desired output being in the "Price" column of Table 1.

Table 1:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]Column A[/TD]
[TD="align: center"]Column B[/TD]
[TD="align: center"]Column C[/TD]
[TD="align: center"]Column D[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD="align: center"]Thickness[/TD]
[TD="align: center"]Type[/TD]
[TD="align: center"]Width[/TD]
[TD="align: center"]Price[/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]Flat[/TD]
[TD]A1[/TD]
[TD]1.5[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD]Thick[/TD]
[TD]B1[/TD]
[TD]3[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]Thin[/TD]
[TD]A1[/TD]
[TD]1[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]

Table 2:
[TABLE="width: 292"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]Column A[/TD]
[TD="align: center"]Column B[/TD]
[TD="align: center"]Column C[/TD]
[TD="align: center"]Column D[/TD]
[TD="align: center"]Column E[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD="align: center"]Thickness[/TD]
[TD="align: center"]Min. Width[/TD]
[TD="align: center"]Max. Width[/TD]
[TD="align: center"]A1[/TD]
[TD="align: center"]B1[/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]Flat[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]$2[/TD]
[TD]$6[/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD]Flat[/TD]
[TD]1.1[/TD]
[TD]2[/TD]
[TD]$3[/TD]
[TD]$6[/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]Thick[/TD]
[TD]3[/TD]
[TD]3.5[/TD]
[TD]$4[/TD]
[TD]$7[/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]Thin[/TD]
[TD]0[/TD]
[TD]0.5[/TD]
[TD]$5[/TD]
[TD]$8[/TD]
[/TR]
[TR]
[TD]Row 5[/TD]
[TD]Thin[/TD]
[TD]0.6[/TD]
[TD]0.9[/TD]
[TD]$4[/TD]
[TD]$7[/TD]
[/TR]
[TR]
[TD]Row 6[/TD]
[TD]Thin[/TD]
[TD]1[/TD]
[TD]1.2[/TD]
[TD]$5[/TD]
[TD]$8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I need to find an exact match of columns A and B from Table 1 in Table 2 and then find which range my value in Column C from Table 1 fits in and pull the price where all of these occur.

I have been able to do a combination VLOOKUP HLOOKUP for the type and width but adding in the third criteria of thickness is causing my issue. I tried to do an index-match formula but I'm having trouble since I need it to partial perform exact matches and then only an approximate match for the width.

Does anyone have any recommendations on how an index match might be able to help with this? Or if there is another way I could accomplish this I'd appreciate any insight! Thank you!

 

[AhoyNC]

See if this might work.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D
1	Thickness	Type	Width	Price
2	Flat	A1	1.5	3
3	Thick	B1	3	7
4	Thin	A1	1	5
Table1

Excel Workbook
	A	B	C	D	E
1	Thickness	Min. Width	Max. Width	A1	B1
2	Flat	0	1	$2	$6
3	Flat	1.1	2	$3	$6
4	Thick	3	3.5	$4	$7
5	Thin	0	0.5	$5	$8
6	Thin	0.6	0.9	$4	$7
7	Thin	1	1.2	$5	$8
Table2