MAX Formula Assistance

[Disarmonious]

Hello,

I have 4 columns named: "Blended" F30; "Construct" G30; "Intercept" H30; "Acquired" I30. Just below those columns (F31:I31), production totals for each column is calculated. I would like cell S21 to display the column name with the highest value below it.

 

[dreid1011]

Perhaps this:

=INDEX(F30:I30,,MATCH(MAX(F31:I31),F31:I31,0))

 

[knacksc2]

=IF(HLOOKUP("Blended",F30:I31,2,FALSE)=MAX(F31,G31,H31,I31),"Blended",IF(HLOOKUP("Construct",F30:I31,2,FALSE)=MAX(F31,G31,H31,I31),"Construct",IF(HLOOKUP("Intercept",F30:I31,2,FALSE)=MAX(F31,G31,H31,I31),"Intercept",IF(HLOOKUP("Acquired",F30:I31,2,FALSE)=MAX(F31,G31,H31,I31),"Acquired"))))

 

[Disarmonious]

dreid1011,

Awesome! Just how I needed it to work. Thank you again!

 

[dreid1011]

You're welcome. Thanks for the feedback.