• 460K Members
• 10.4K Online
• 558K Conversations

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

# Re: Index/Match help

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies