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

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
Asked:
bvanscoy678
  • 2
1 Solution
 
Rory ArchibaldCommented:
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
 
bvanscoy678Author 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
 
bvanscoy678Author 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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now