Show category with highest spend data

[joeburg]

Hello, I'm trying to sort a list of suppliers that has spend filtered by department.

What I want to do is find the department that spends the most with a supplier and list that on a separate list. I have included an example in the workbook attached

Is this thing possible? I thought maybe a HLOOKUP but couldn't figure it out

[Bo_Ry]

Please try at D20

=INDEX($D$4:$G$4,MATCH(MAX(D5:G5),D5:G5,))


or if Supplier is not sort
=INDEX($D$4:$G$4,MATCH(MAX(INDEX($D$5:$G$14,MATCH(C20,$C$5:$C$14,),)),INDEX($D$5:$G$14,MATCH(C20,$C$5:$C$14,),),))

[joeburg]

Please try at D20

=INDEX($D$4:$G$4,MATCH(MAX(D5:G5),D5:G5,))


or if Supplier is not sort
=INDEX($D$4:$G$4,MATCH(MAX(INDEX($D$5:$G$14,MATCH(C20,$C$5:$C$14,),)),INDEX($D$5:$G$14,MATCH(C20,$C$5:$C$14,),),))

Perfect! thank you so much