Home

Index/Match help

Zkgabriel
New 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) )
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies