=INDEX(C1:F1,,MATCH(MIN(C2:F2),C2:F2,0))

--
Kind regards,

Niek Otten

"DKY" wrote in message ...

How do I grab the column number to this function
MIN(C2:F2)

Actually, what I'm looking to do is display the header of whatever the
answer to the above function is. All the headers are in row 1. So in
essence, if the min is in column D then it will display the data in D1.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315