Could I use HLOOKUP for answering multiple questions for a query return?

[David Brownell]

I need to answer 2 questions from the table below to return a query from below the temperature range tables
I need to ask CSN #, and then ask the operating temperature, returning a query from the stress table below.

example:
CSN 6, with an operating temperature of 550, returning the answer 13700.

Would like to do this with HLOOKUP command if possible, but am flexible. I could also possibly modify the table, although I do use it for other functions.

Thank you

																		allowable stresses in tension for metals not exceeding temperature Fo
CSN	Code	Spec	Grade	Class	Sch	Tensile ksi	Yield ksi	E	-20-100	101-200	201-300	301-400	401-500	501-600	601-650	651-700	701-750	751-800	801-850	851-900	901-950	951-1000	1001-1050	1051-1100
1	B31.1	A53	A	SMLS	STD	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9000	-	-	-	-	-	-
2	B31.1	A53	A	SMLS	XS	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9000	-	-	-	-	-	-
3	B31.1	A53	A	ERW	STD	48	30	0.85	11700	11700	11700	11700	11700	11700	11700	10600	9100	7700	-	-	-	-	-	-
4	B31.1	A53	A	ERW	XS	48	30	0.85	11700	11700	11700	11700	11700	11700	11700	10600	9100	7700	-	-	-	-	-	-
5	B31.1	A106	A	SMLS	STD	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9300	-	-	-	-	-	-
6	B31.1	A106	A	SMLS	XS	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9300	-	-	-	-	-	-
7	B31.1	A53	B	SMLS	STD	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-	-	-	-	-	-
8	B31.1	A53	B	SMLS	XS	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-	-	-	-	-	-
9	B31.1	A53	B	ERW	STD	60	35	0.85	14600	14600	14600	14600	14600	14600	14600	13300	11100	9200	-	-	-	-	-	-
10	B31.1	A53	B	ERW	XS	60	35	0.85	14600	14600	14600	14600	14600	14600	14600	13300	11100	9200	-	-	-	-	-	-
11	B31.1	A106	B	SMLS	STD	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-	-	-	-	-	-
12	B31.1	A106	B	SMLS	XS	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-	-	-	-	-	-
13	B31.1	A106	C	SMLS	STD	70	40	1	20000	20000	20000	20000	20000	20000	19800	18300	14800	12000	-	-	-	-	-	-
14	B31.1	A106	C	SMLS	XS	70	40	1	20000	20000	20000	20000	20000	20000	19800	18300	14800	12000	-	-	-	-	-	-
15	B31.3	A53	A	SMLS	STD	48	30	1	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
16	B31.3	A53	A	SMLS	XS	48	30	1	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
17	B31.3	A53	A	ERW	STD	48	30	0.85	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
18	B31.3	A53	A	ERW	XS	48	30	0.85	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
19	B31.3	A106	A	SMLS	STD	48	30	1	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
20	B31.3	A106	A	SMLS	XS	48	30	1	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
21	B31.3	API 5L	A	SMLS	STD	48	30	1	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
22	B31.3	API 5L	A	ERW	STD	48	30	0.85	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
23	B31.3	API 5L	A	SMLS	STD	48	30	1	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
24	B31.3	API 5L	A	ERW	STD	48	30	0.85	16000	16000	16000	16000	16000	15300	14600	12500	10700	9200	7900	5900	4000	2500	1600	1000
25	B31.3	A53	B	SMLS	STD	60	35	1	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
26	B31.3	A53	B	SMLS	XS	60	35	1	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
27	B31.3	A53	B	ERW	STD	60	35	0.85	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
28	B31.3	A53	B	ERW	XS	60	35	0.85	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
29	B31.3	A106	B	SMLS	STD	60	35	1	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
30	B31.3	A106	B	SMLS	XS	60	35	1	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
31	B31.3	API 5L	B	SMLS	STD	60	35	1	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
32	B31.3	API 5L	B	ERW	STD	60	35	0.85	20000	20000	20000	19900	19000	17900	17300	16700	13900	11400	8700	5900	4000	2500	1600	1000
33	B31.3	A106	C	SMLS	STD	70	40	1	23300	23300	23300	22800	21700	20400	19800	18300	14800	12000	-	-	-	-	-	-
34	B31.3	A106	C	SMLS	XS	70	40	1	23300	23300	23300	22800	21700	20400	19800	18300	14800	12000	-	-	-	-	-	-

<colgroup><col style="mso-width-source:userset;mso-width-alt:597; width:11pt" width="14" span="50"> </colgroup><tbody>
</tbody>

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1					6	550		13700		allowable stresses in tension for metals not exceeding temperature Fo
2	CSN	Code	Spec	Grade	Class	Sch	Tensile ksi	Yield ksi	E	-20	101	201	301	401	501	601	651	701	751	801
3	1	B31.1	A53	A	SMLS	STD	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9000	-
4	2	B31.1	A53	A	SMLS	XS	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9000	-
5	3	B31.1	A53	A	ERW	STD	48	30	0.85	11700	11700	11700	11700	11700	11700	11700	10600	9100	7700	-
6	4	B31.1	A53	A	ERW	XS	48	30	0.85	11700	11700	11700	11700	11700	11700	11700	10600	9100	7700	-
7	5	B31.1	A106	A	SMLS	STD	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9300	-
8	6	B31.1	A106	A	SMLS	XS	48	30	1	13700	13700	13700	13700	13700	13700	13700	12500	10700	9300	-
9	7	B31.1	A53	B	SMLS	STD	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-
10	8	B31.1	A53	B	SMLS	XS	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-
11	9	B31.1	A53	B	ERW	STD	60	35	0.85	14600	14600	14600	14600	14600	14600	14600	13300	11100	9200	-
12	10	B31.1	A53	B	ERW	XS	60	35	0.85	14600	14600	14600	14600	14600	14600	14600	13300	11100	9200	-
13	11	B31.1	A106	B	SMLS	STD	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-
14	12	B31.1	A106	B	SMLS	XS	60	35	1	17100	17100	17100	17100	17100	17100	17100	15600	13000	10800	-
15	13	B31.1	A106	C	SMLS	STD	70	40	1	20000	20000	20000	20000	20000	20000	19800	18300	14800	12000	-
Summary

Cell Formulas
Range	Formula
H1	=INDEX(J3:Y36,MATCH(E1,A3:A36,0),MATCH(F1,J2:Y2,1))

 

[David Brownell]

Fluff,
You made it so simple! Thank you so much.
David

 

[Fluff]

You're welcome & thanks for the feedback