Match Cell Value to relevant heading

[SteveT57]

Hi I am trying match the largest cell value in a row to the relevant Heading & am struggling to come up with the right formula. I am trying to get the result in the Column Outcome. Example data is below. I have tried this formula with no luck =IFERROR(INDEX(R5:V15,MATCH(MAX(R7:V7),R7:V7,0),1),"no match")

All Star	Traffic Driver	Margin Driver	Churner	Loser	Outcome
1		3	3		Margin Driver
1		3		1
3		7
1		9
2		15	5	12	15

<tbody>
</tbody>

Thanks in advance SteveT

 

[DWig]

Just on first glance, it looks to me that your column and row references could be backward. You're trying to return the column title, correct?

Index/Match goes array, row number, column number. You're running your lookup to select a row right now, and it should be running to select a column for which you'll return the value in row 1.

Simple fix: switch the position of your MATCH function and the "1", such as:

=IFERROR(INDEX(R5:V15,1,MATCH(MAX(R7:V7),R7:V7,0)),"no match")

How are you handling it if there are two cells in a row that are tied for the largest value? In your example, I got "Churner" for my outcome in the first row of testable data. If I changed the margin driver value to 4, it returned that. However, in your example, it's returning margin driver. Just something you might want to address.

DWig