Jan 05 2019 10:26 PM
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
Jan 07 2019 01:53 AM
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) )