table lookup with two inputs one output
 

I want to take two input values and look up the 1st in the A1 column, then
take the 2nd (using the row associated with the first) and find the column (a
value that is less than the 2nd) of the 2nd input. Then output the column
heading. I have a sample table below.

150 Class 300 Class 600 Class 900 Class
Temp Pressure Pressure Pressure Pressure
t1 1 1.5 2 2.5
t2 2 2.5 3 3.5
t3 3 3.5 4 4.5
t4 4 4.5 5 5.5
t5 5 5.5 6 6.5
t6 6 6.5 7 7.5

So, if input 1 is "t2" and input 2 is 2.9, I want an output of "600 Class"

Any help on this is greatly appreciated.

Charlie

table lookup with two inputs one output
 

=INDEX(A1:E1,0,MATCH(G2,INDIRECT(MATCH(G1,$A$1:$A$ 8,0)&":"&MATCH(G1,$A$1:$A$8,0)),1))

Which gives 300 Class which value less than 2.9

HTH

"cobra_charlie" wrote:

I want to take two input values and look up the 1st in the A1 column, then
take the 2nd (using the row associated with the first) and find the column (a
value that is less than the 2nd) of the 2nd input. Then output the column
heading. I have a sample table below.

150 Class 300 Class 600 Class 900 Class
Temp Pressure Pressure Pressure Pressure
t1 1 1.5 2 2.5
t2 2 2.5 3 3.5
t3 3 3.5 4 4.5
t4 4 4.5 5 5.5
t5 5 5.5 6 6.5
t6 6 6.5 7 7.5

So, if input 1 is "t2" and input 2 is 2.9, I want an output of "600 Class"

Any help on this is greatly appreciated.

Charlie

table lookup with two inputs one output
 

...sorry ...

G1=t2
G2=2.9

"Toppers" wrote:



=INDEX(A1:E1,0,MATCH(G2,INDIRECT(MATCH(G1,$A$1:$A$ 8,0)&":"&MATCH(G1,$A$1:$A$8,0)),1))

Which gives 300 Class which value less than 2.9

HTH

"cobra_charlie" wrote:

I want to take two input values and look up the 1st in the A1 column, then
take the 2nd (using the row associated with the first) and find the column (a
value that is less than the 2nd) of the 2nd input. Then output the column
heading. I have a sample table below.

150 Class 300 Class 600 Class 900 Class
Temp Pressure Pressure Pressure Pressure
t1 1 1.5 2 2.5
t2 2 2.5 3 3.5
t3 3 3.5 4 4.5
t4 4 4.5 5 5.5
t5 5 5.5 6 6.5
t6 6 6.5 7 7.5

So, if input 1 is "t2" and input 2 is 2.9, I want an output of "600 Class"

Any help on this is greatly appreciated.

Charlie

table lookup with two inputs one output
 

Thank you, it worked like a charm.

"Toppers" wrote:

..sorry ...

G1=t2
G2=2.9

"Toppers" wrote:



=INDEX(A1:E1,0,MATCH(G2,INDIRECT(MATCH(G1,$A$1:$A$ 8,0)&":"&MATCH(G1,$A$1:$A$8,0)),1))

Which gives 300 Class which value less than 2.9

HTH

"cobra_charlie" wrote:

I want to take two input values and look up the 1st in the A1 column, then
take the 2nd (using the row associated with the first) and find the column (a
value that is less than the 2nd) of the 2nd input. Then output the column
heading. I have a sample table below.

150 Class 300 Class 600 Class 900 Class
Temp Pressure Pressure Pressure Pressure
t1 1 1.5 2 2.5
t2 2 2.5 3 3.5
t3 3 3.5 4 4.5
t4 4 4.5 5 5.5
t5 5 5.5 6 6.5
t6 6 6.5 7 7.5

So, if input 1 is "t2" and input 2 is 2.9, I want an output of "600 Class"

Any help on this is greatly appreciated.

Charlie