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

=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

Thanks a lot. But there is something else. I want to A1:D1 be always
same.
When I drag formula it changes to A2:D2. So that it causes taking wrong
answer.

I need your help again:)


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

change a1:d1 to $a$1:$d$1



shenkly2 wrote:

Thanks a lot. But there is something else. I want to A1:D1 be always
same.
When I drag formula it changes to A2:D2. So that it causes taking wrong
answer.

I need your help again:)

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

--

Dave Peterson

Thanks a lot.


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