Urgent!!!

S

shenkly2

Hi All,

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

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

Thanks in advance
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
S

shenkly2

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

I need your help again:
 
D

Dave Peterson

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


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:)
Click to expand...
 
Top