Identifying MAX column header

**Canucklehead** · 10-07-2009, 08:29 AM

There is probably a really easy solution to this, but I can't for the life of me figure one out and I am not having any luck with the googles.

I am using a MAX function to identify the top revenue/cost/profit measures but I also want to identify which branch had the top-performing measure. I've attached a small sample that will, hopefully, show what I mean more clearly.

Any help would be appreciated.

Thanks!

**NBVC** · 10-07-2009, 08:37 AM

Try:

=INDEX($B$2:$D$2,MATCH(E3,B3:D3,0))

copied down

**Canucklehead** · 10-07-2009, 08:41 AM

Thanks, that worked wonders. Now, if I could only understand why... Guess I'll be doing some reading this morning.

**NBVC** · 10-07-2009, 08:52 AM

Match() matches the value in E3 to values in B3:D3 and finds the position of the first match it comes across... then Index() indexes the header range and returns, the value at the same position that the Match() argument returned...

It is a bit like Hlookup reversed so that you can lookup above the lookup range instead of just below....

**Canucklehead** · 10-07-2009, 08:57 AM

I am still puzzling my way through it; it will just take practice and fooling around a bit with these new-to-me functions. Thanks for taking the time to explain.