Need help with nested IF() fucntion.

[ExcelLuv92]

Hello,

I'm trying to create a visual data dashboard for my company. This particular data gauge will show what the top order delay reason was for a given time period.

I need help writing an IF() function for it. I'm trying to get the needle on this gauge to line up in the middle of the correct label depending on which number from the data located in A28:B33 is bigger. This data is reference to data located in a pivot chart using the GETPIVOTDATA() function.

So for the guage currently shown I have the function =IF(B29>B30,F29,F30) located in D19.

How do I compare all of the data in A28:B33 to return the correct midpoint ?

 

[gsistek]

Try:
=INDEX(F29:F33,MATCH(MAX(B29:B33),B29:B33,0))