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

D

David Brownell

New Member
Joined
Mar 29, 2019
Messages
6
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



<colgroup><col style="mso-width-source:userset;mso-width-alt:597; width:11pt" width="14" span="50"> </colgroup><tbody>
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl65, width: 14"][/TD]
[TD="class: xl68, width: 448, colspan: 32"]allowable stresses in tension for metals not exceeding temperature F o [/TD]

[TD="class: xl68, colspan: 2"]CSN[/TD]
[TD="class: xl71, colspan: 2"]Code[/TD]
[TD="class: xl67, colspan: 2"]Spec[/TD]
[TD="class: xl67, colspan: 2"]Grade[/TD]
[TD="class: xl67, colspan: 2"]Class[/TD]
[TD="class: xl67, colspan: 2"]Sch[/TD]
[TD="class: xl67, colspan: 2"]Tensile ksi[/TD]
[TD="class: xl67, colspan: 2"]Yield ksi[/TD]
[TD="class: xl68, colspan: 2"]E[/TD]
[TD="class: xl68, colspan: 2"] -20-100[/TD]
[TD="class: xl68, colspan: 2"]101-200[/TD]
[TD="class: xl68, colspan: 2"]201-300[/TD]
[TD="class: xl68, colspan: 2"]301-400[/TD]
[TD="class: xl68, colspan: 2"]401-500[/TD]
[TD="class: xl68, colspan: 2"]501-600[/TD]
[TD="class: xl68, colspan: 2"]601-650[/TD]
[TD="class: xl68, colspan: 2"]651-700[/TD]
[TD="class: xl68, colspan: 2"]701-750[/TD]
[TD="class: xl68, colspan: 2"]751-800[/TD]
[TD="class: xl68, colspan: 2"]801-850[/TD]
[TD="class: xl68, colspan: 2"]851-900[/TD]
[TD="class: xl68, colspan: 2"]901-950[/TD]
[TD="class: xl68, colspan: 2"]951-1000[/TD]
[TD="class: xl68, colspan: 2"]1001-1050[/TD]
[TD="class: xl68, colspan: 2"]1051-1100[/TD]

[TD="class: xl66, colspan: 2"]1[/TD]
[TD="class: xl69, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9000[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]2[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9000[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]3[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]10600[/TD]
[TD="class: xl68, colspan: 2"]9100[/TD]
[TD="class: xl68, colspan: 2"]7700[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]4[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]11700[/TD]
[TD="class: xl68, colspan: 2"]10600[/TD]
[TD="class: xl68, colspan: 2"]9100[/TD]
[TD="class: xl68, colspan: 2"]7700[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl66, colspan: 2"]5[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9300[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]6[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]13700[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9300[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]7[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]15600[/TD]
[TD="class: xl68, colspan: 2"]13000[/TD]
[TD="class: xl68, colspan: 2"]10800[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]8[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]15600[/TD]
[TD="class: xl68, colspan: 2"]13000[/TD]
[TD="class: xl68, colspan: 2"]10800[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl66, colspan: 2"]9[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]13300[/TD]
[TD="class: xl68, colspan: 2"]11100[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]10[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]13300[/TD]
[TD="class: xl68, colspan: 2"]11100[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]11[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]15600[/TD]
[TD="class: xl68, colspan: 2"]13000[/TD]
[TD="class: xl68, colspan: 2"]10800[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]12[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]17100[/TD]
[TD="class: xl68, colspan: 2"]15600[/TD]
[TD="class: xl68, colspan: 2"]13000[/TD]
[TD="class: xl68, colspan: 2"]10800[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl66, colspan: 2"]13[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]C[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]70[/TD]
[TD="class: xl68, colspan: 2"]40[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19800[/TD]
[TD="class: xl68, colspan: 2"]18300[/TD]
[TD="class: xl68, colspan: 2"]14800[/TD]
[TD="class: xl68, colspan: 2"]12000[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]14[/TD]
[TD="class: xl66, colspan: 2"]B31.1[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]C[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]70[/TD]
[TD="class: xl68, colspan: 2"]40[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19800[/TD]
[TD="class: xl68, colspan: 2"]18300[/TD]
[TD="class: xl68, colspan: 2"]14800[/TD]
[TD="class: xl68, colspan: 2"]12000[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]15[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]16[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl66, colspan: 2"]17[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]18[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]19[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]20[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl66, colspan: 2"]21[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]API 5L[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]22[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]API 5L[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]23[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]API 5L[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]24[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]API 5L[/TD]
[TD="class: xl68, colspan: 2"]A[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]48[/TD]
[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]16000[/TD]
[TD="class: xl68, colspan: 2"]15300[/TD]
[TD="class: xl68, colspan: 2"]14600[/TD]
[TD="class: xl68, colspan: 2"]12500[/TD]
[TD="class: xl68, colspan: 2"]10700[/TD]
[TD="class: xl68, colspan: 2"]9200[/TD]
[TD="class: xl68, colspan: 2"]7900[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl66, colspan: 2"]25[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]26[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]27[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]28[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A53[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl66, colspan: 2"]29[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]30[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]31[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]API 5L[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl68, colspan: 2"]32[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]API 5L[/TD]
[TD="class: xl68, colspan: 2"]B[/TD]
[TD="class: xl68, colspan: 2"]ERW[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]60[/TD]
[TD="class: xl68, colspan: 2"]35[/TD]
[TD="class: xl68, colspan: 2"]0.85[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]20000[/TD]
[TD="class: xl68, colspan: 2"]19900[/TD]
[TD="class: xl68, colspan: 2"]19000[/TD]
[TD="class: xl68, colspan: 2"]17900[/TD]
[TD="class: xl68, colspan: 2"]17300[/TD]
[TD="class: xl68, colspan: 2"]16700[/TD]
[TD="class: xl68, colspan: 2"]13900[/TD]
[TD="class: xl68, colspan: 2"]11400[/TD]
[TD="class: xl68, colspan: 2"]8700[/TD]
[TD="class: xl68, colspan: 2"]5900[/TD]
[TD="class: xl68, colspan: 2"]4000[/TD]
[TD="class: xl68, colspan: 2"]2500[/TD]
[TD="class: xl68, colspan: 2"]1600[/TD]
[TD="class: xl68, colspan: 2"]1000[/TD]

[TD="class: xl66, colspan: 2"]33[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]C[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]STD[/TD]
[TD="class: xl68, colspan: 2"]70[/TD]
[TD="class: xl68, colspan: 2"]40[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]23300[/TD]
[TD="class: xl68, colspan: 2"]23300[/TD]
[TD="class: xl68, colspan: 2"]23300[/TD]
[TD="class: xl68, colspan: 2"]22800[/TD]
[TD="class: xl68, colspan: 2"]21700[/TD]
[TD="class: xl68, colspan: 2"]20400[/TD]
[TD="class: xl68, colspan: 2"]19800[/TD]
[TD="class: xl68, colspan: 2"]18300[/TD]
[TD="class: xl68, colspan: 2"]14800[/TD]
[TD="class: xl68, colspan: 2"]12000[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

[TD="class: xl68, colspan: 2"]34[/TD]
[TD="class: xl66, colspan: 2"]B31.3[/TD]
[TD="class: xl68, colspan: 2"]A106[/TD]
[TD="class: xl68, colspan: 2"]C[/TD]
[TD="class: xl68, colspan: 2"]SMLS[/TD]
[TD="class: xl68, colspan: 2"]XS[/TD]
[TD="class: xl68, colspan: 2"]70[/TD]
[TD="class: xl68, colspan: 2"]40[/TD]
[TD="class: xl68, colspan: 2"]1[/TD]
[TD="class: xl68, colspan: 2"]23300[/TD]
[TD="class: xl68, colspan: 2"]23300[/TD]
[TD="class: xl68, colspan: 2"]23300[/TD]
[TD="class: xl68, colspan: 2"]22800[/TD]
[TD="class: xl68, colspan: 2"]21700[/TD]
[TD="class: xl68, colspan: 2"]20400[/TD]
[TD="class: xl68, colspan: 2"]19800[/TD]
[TD="class: xl68, colspan: 2"]18300[/TD]
[TD="class: xl68, colspan: 2"]14800[/TD]
[TD="class: xl68, colspan: 2"]12000[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]
[TD="class: xl68, colspan: 2"]-[/TD]

</tbody>
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
How about


Excel 2013/2016
ABCDEFGHIJKLMNOPQRST
1655013700allowable stresses in tension for metals not exceeding temperature Fo
2CSNCodeSpecGradeClassSchTensile ksiYield ksiE-20101201301401501601651701751801
31B31.1A53ASMLSSTD483011370013700137001370013700137001370012500107009000-
42B31.1A53ASMLSXS483011370013700137001370013700137001370012500107009000-
53B31.1A53AERWSTD48300.85117001170011700117001170011700117001060091007700-
64B31.1A53AERWXS48300.85117001170011700117001170011700117001060091007700-
75B31.1A106ASMLSSTD483011370013700137001370013700137001370012500107009300-
86B31.1A106ASMLSXS483011370013700137001370013700137001370012500107009300-
97B31.1A53BSMLSSTD6035117100171001710017100171001710017100156001300010800-
108B31.1A53BSMLSXS6035117100171001710017100171001710017100156001300010800-
119B31.1A53BERWSTD60350.851460014600146001460014600146001460013300111009200-
1210B31.1A53BERWXS60350.851460014600146001460014600146001460013300111009200-
1311B31.1A106BSMLSSTD6035117100171001710017100171001710017100156001300010800-
1412B31.1A106BSMLSXS6035117100171001710017100171001710017100156001300010800-
1513B31.1A106CSMLSSTD7040120000200002000020000200002000019800183001480012000-
Summary
Cell Formulas
RangeFormula
H1=INDEX(J3:Y36,MATCH(E1,A3:A36,0),MATCH(F1,J2:Y2,1))
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,909
Messages
6,175,314
Members
452,634
Latest member
cpostell

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top