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 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
1 Reply
- SergeiBaklanDiamond Contributor
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) )