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