Forum Discussion
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...
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) )