• 509K Members
• 6,256 Online
• 605K Conversations

Highlighted
New Contributor

# Index/Match help

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

 Weight 40 50 60 1 1000 6000 10500 Gravity Weight 10 #N/A 2 1500 6500 11000 Temp 60 60 3 2000 7000 11500 Gravity 15000 15000 4 2500 7500 12000 5 3000 8000 12500 6 3500 8500 13000 7 4000 9000 13500 8 4500 9500 14000 9 5000 10000 14500 10 5500 10500 15000

thanks again for the help

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