=TEXT(MIN(C2:F2),"FormatString")&" "&(INDEX(C$1:F$1,1,MATCH(MIN(C2:F2),C2:F2,0)))

Replace FormatString with your format string. You can find it by formatting a cell as $ and then choose FormatCellsNumber tab,
Custom and copy the format string from the Type box.
It has to be in quotes in your formula.

--
Kind regards,

Niek Otten



"DKY" wrote in message ...

DKY Wrote:
That works, thanks

One other question, how do I format this
MIN(C2:F2)
into Dollars, same format as when I hit the $ button.

Let me explain this a little more, I wanted to add
MIN(C2:F2)
to this
INDEX(C$1:F$1,1,MATCH(MIN(C2:F2),C2:F2,0))
so that it looks like this
MIN(C2:F2)&" "&(INDEX(C$1:F$1,1,MATCH(MIN(C2:F2),C2:F2,0)))
but I want to format this part
MIN(C2:F2)
into Dollars and not the rest of it. Is that possible?


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