Formula to return lowest value of 3 datapoints

[Guest]

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")))))))

 

[Don Guillett]

Does this help. It will give the column NUMBER.

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

 

[Guest]

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")))))))

 

[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))