• Status: Solved
• Priority: Medium
• Security: Public
• Views: 371

# Index and Match to find header value

Hello,

I have been working on index and match functions and have a pretty good idea on their normal uses. But, I am confused on the attached example.

I have the age and score (the score is the value that is the main part of my table) and I want to return the value of the header in the column of my value.

In my example I have a 45 year old male and with my match formulas places it in the 3rd position (also the 3rd row of my table), then the score of 33 places it in the D column of my table (D5). I highlighted to show the positions and the header values "TIER 2" is what I want to return.

I know I want to use the match value of my age group (in this example it is 3) Then I will limit my search to that row to come up with the correct column to obtain my "tier level" for the age and score. Just not sure how to do it.

Thanks for any help. Brent
EE-Question.xlsx
0
bvanscoy678
• 2
1 Solution

Commented:
I think you want:
=INDEX(\$B\$5:\$E\$5,MATCH(J2,INDEX(\$B\$6:\$E\$9,MATCH(I2,\$A\$6:\$A\$9,1),0),1))
0

Author Commented:
It looks like it works. I'll need to print it off and study it a bit deeper. I'll post right back. Thanks.
0

Author Commented:
I get what it is doing, although it will take me a bit of time to apply it to the other chart. Thanks for the help! Brent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.