[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Index and Match to find header value

Posted on 2013-06-05
Medium Priority
368 Views
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
Question by:bvanscoy678
• 2

LVL 85

Accepted Solution

Rory Archibald earned 2000 total points
ID: 39222583
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 Comment

ID: 39222612
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 Closing Comment

ID: 39222688
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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
###### Suggested Courses
Course of the Month20 days, 4 hours left to enroll