Index/Match trouble with returning text value
My goal here is retrieve the Row 1 values(grey cell color) based on where the match cell (value = 14) in this case falls under. I added a row identical to the column header values to try to get this method to work but if there is a way to retrieve the column header for the top 3 highest values in a row please let know. Thanks.
Best Answer
-
The problem is the location of your MATCH. Your MATCH function is in the place that determines the row to pull from in the INDEX function. Replace that with 1 and move the MATCH to the 3rd portion of the INDEX function that specifies which column to pull from.
Answers
-
Within the function the blacked out text is the row 1 range (Grey cell color), and the range of numbers respectively.
-
The problem is the location of your MATCH. Your MATCH function is in the place that determines the row to pull from in the INDEX function. Replace that with 1 and move the MATCH to the 3rd portion of the INDEX function that specifies which column to pull from.
-
Tried that but it returned the first text value in the search range not the text value corresponding to the number highlighted (14).
-
Updated the range of the match column to be the range of the values (7, 14, etc.) and it worked now.
Help Article Resources
Categories
Check out the Formula Handbook template!