Formula that pulls a value based on 2 different criteria ranges

I moved the table E1:I5 down one row to make room for the width range headers. (See below.)

Then in C2 and filled down

Formula:

Please Login or Register  to view this content.

	A	B	C	D	E	F	G	H	I	J
1	Gauge	Width	Cost $				Width
2	0.1210	50	$ -		Min Gauge		36	42	48
3	0.0900	46	$ 1.50		Under	Thru	42	48	72
4	0.1050	38	$ 3.00		0.6250	0.0810	$ 3.00	$ 1.50	$ -
5	0.1210	46	$ 1.50		0.0810	0.0660	$ 3.50	$ 2.00	$ 0.50
6	0.0900	70	$ -		0.0660	0.0560	$ 5.50	$ 4.00	$ 2.50
7	0.1050	46	$ 1.50

Hello osugirl7 ,

In case you don't want to change set up then copy paste below in C2 and drag down

Formula:

Please Login or Register  to view this content.

Thanks for the feedback and REP Osugirl7

Same here osugirl, and thank you for marking your thread Solved.