Hi,

What I am trying to do is look for the max value in a row and return
the relevant column header

Example:

1-----2-----3-----4------5-----6-----7----

35---29----16----3----21----45----5----

So, the function should look down a row, find the max value of 45 and
return the column header of 6.

I have been tryinga combination of hlookup and max value but haven't
been able to product the desired results.

Any help would be greatly appreciated.

swjtx


--
swjtx
------------------------------------------------------------------------
swjtx's Profile: http://www.excelforum.com/member.php...o&userid=29716
View this thread: http://www.excelforum.com/showthread...hreadid=494418