Index Formula help

[Abell]

Hi All,

Looking for help with a formula that would populate the division under the classification column based on which division has the highest sales # for that account number. Example attached

Thank you!!

[Bo_Ry]

Please try at G2
=INDEX(B$1:F$1,MATCH(MAX(B2:F2),B2:F2,))

[Abell]

That worked thank you!