=INDEX(A1:D1,MATCH(MINA(A2:D2),A2:D2,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"shenkly2" wrote in
message ...

Hi All,

I need your help. I want to find min price between several prices. No
problem with this. I use MinA(A2;B2;C2;D2). I can find min price, but I
also want to bring company name next to min price. Header line is
A1,B1,C1,D1. I mean I want to bring header line of min price next to
min price colum.

How can I do it? I am sure this is very easy for someof you. I need
your help:)

Thanks in advance.


--
shenkly2
------------------------------------------------------------------------
shenkly2's Profile:
http://www.excelforum.com/member.php...o&userid=30965
View this thread: http://www.excelforum.com/showthread...hreadid=506316