table lookup with two inputs one output

C

cobra_charlie

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
 
T

Toppers

=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
 
T

Toppers

...sorry ...

G1=t2
G2=2.9

Toppers said:
=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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condtional Formatting 6
table lookup 3
look up value in a table 2
Conditional Formatting 0
HLOOKUP PROBLEM 4
Lookup Table 1
Automating change via popup to a column of numbers 0
Create Table From Another Table 2

Top