Formula to return lowest value of 3 datapoints

E

Enzo

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(MIN(Q10:S10),"A","B","C")))))))
 
D

Don Guillett

Does this help. It will give the column NUMBER.

=MATCH(MIN(H20:J20),20:20)
 
E

Enzo

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(MIN(Q10:S10),"A","B","C")))))))
 
D

Don Guillett

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top