Index/Match trouble with returning text value

SebastienD

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.

index_Match.jpg

Paul Newcome

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.

SebastienD

Within the function the blacked out text is the row 1 range (Grey cell color), and the range of numbers respectively.

Paul Newcome

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.

SebastienD

Tried that but it returned the first text value in the search range not the text value corresponding to the number highlighted (14).

SebastienD

Updated the range of the match column to be the range of the values (7, 14, etc.) and it worked now.