Index/Match help

Copper Contributor

ok so it looks like in my fuddling i managed to make my table more complicated and am hoping to solve it none the less.  

 

i've uploaded the table i'm working on. 

i managed to get it to work one way. but what i would like to do is be able to enter in my Temp and Gravity and have it bring back the Weight the problem is i keep coming up with #n/a 

 

i'm using the code : 

i was able to get the weight to come up by entering temp and gravity using 

=INDEX($A$2:$D$12, MATCH($G$3,$A$2:$A$12,0), MATCH($G$4,$A$2:$D$2,0))

but i was hoping it would work the other way pulling Temp and Gravity using the following: 

=INDEX($A$2:$D$12, MATCH($H$5,$B$3:$D$12,0), MATCH($G$4,$A$2:$D$2,0))

 

 

 

  Temp        

Weight405060    
11000600010500GravityWeight10#N/A
21500650011000Temp6060
32000700011500Gravity1500015000
42500750012000   
53000800012500   
63500850013000   
74000900013500   
84500950014000    
950001000014500    
1055001050015000    

 

 

thanks again for the help

1 Reply

Hi,

 

MATCH returns the position of the value within an array, not matrix. Thus you may first to find the column for Temp and within this column to find the Gravity position, with that index return the Weight.

Like

=INDEX($A$3:$A$12, MATCH($H$5,OFFSET($A$3:$A$12,0,MATCH($G$4,$B$2:$D$2,0)),0) )