Formula to return lowest value of 3 datapoints
 

I used the MIN formula to compare three cells and return the lowest value.

Now I want to compare the same three cells and return the "column name" with
the lowest value.

I've tried this formula and it only compares the first two values. What am
I doing wrong?

=IF(Q10="","A",(IF(R10="","B",(IF(S10="","C",(IF(M IN(Q10:S10),"A","B","C")))))))

Formula to return lowest value of 3 datapoints
 

Does this help. It will give the column NUMBER.

=MATCH(MIN(H20:J20),20:20)
--
Don Guillett
SalesAid Software

"Enzo" wrote in message
...
I used the MIN formula to compare three cells and return the lowest value.

Now I want to compare the same three cells and return the "column name"
with
the lowest value.

I've tried this formula and it only compares the first two values. What
am
I doing wrong?

=IF(Q10="","A",(IF(R10="","B",(IF(S10="","C",(IF(M IN(Q10:S10),"A","B","C")))))))

Formula to return lowest value of 3 datapoints
 

Thank you for such a quick reply and your help. Hope this explains the
problem better -- what name I've given the "column header".

Column Q = Vendor A
Column R = Vendor B
Column S = Vendor C

Under each column header, is their U/P for a item. So, for example: A1= $1,
B1= $0.95, C1 = $0.70. I want to compare the prices, and return the vendor's
name with the lowest price vs the actual price in a new column.

I created this formula, and it only returns the lowest value of Vendor A & B
-- it's not considering vendor C's price.

=IF(Q10="","A",(IF(R10="","B",(IF(S10="","C",(IF(M IN(Q10:S10),"A","B","C")))))))

"Don Guillett" wrote:


Does this help. It will give the column NUMBER.

=MATCH(MIN(H20:J20),20:20)
--
Don Guillett
SalesAid Software

"Enzo" wrote in message
...
I used the MIN formula to compare three cells and return the lowest value.

Now I want to compare the same three cells and return the "column name"
with
the lowest value.

I've tried this formula and it only compares the first two values. What
am
I doing wrong?

=IF(Q10="","A",(IF(R10="","B",(IF(S10="","C",(IF(M IN(Q10:S10),"A","B","C")))))))

Formula to return lowest value of 3 datapoints
 

Assuming vendor names in row 1 and minimum numbers to find are in row 20

=INDEX(1:1,MATCH(MIN(H20:J20),20:20))

--
Don Guillett
SalesAid Software

"Enzo" wrote in message
...
Thank you for such a quick reply and your help. Hope this explains the
problem better -- what name I've given the "column header".

Column Q = Vendor A
Column R = Vendor B
Column S = Vendor C

Under each column header, is their U/P for a item. So, for example: A1=
$1,
B1= $0.95, C1 = $0.70. I want to compare the prices, and return the
vendor's
name with the lowest price vs the actual price in a new column.

I created this formula, and it only returns the lowest value of Vendor A &
B
-- it's not considering vendor C's price.

=IF(Q10="","A",(IF(R10="","B",(IF(S10="","C",(IF(M IN(Q10:S10),"A","B","C")))))))

"Don Guillett" wrote:


Does this help. It will give the column NUMBER.

=MATCH(MIN(H20:J20),20:20)
--
Don Guillett
SalesAid Software

"Enzo" wrote in message
...
I used the MIN formula to compare three cells and return the lowest
value.

Now I want to compare the same three cells and return the "column name"
with
the lowest value.

I've tried this formula and it only compares the first two values.
What
am
I doing wrong?

=IF(Q10="","A",(IF(R10="","B",(IF(S10="","C",(IF(M IN(Q10:S10),"A","B","C")))))))