Selecting Lowest Value

[rthompson55125]

Hi, I have thousands of lines and trying to find the lowest value per line, yet I need to identify which supplier is the lowest by (on line 1) . Looking for help in this scenario.

[TABLE="width: 440"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] Supplier A[/TD]
[TD] Supplier B[/TD]
[TD] Supplier C[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Part A[/TD]
[TD] $ 2.00[/TD]
[TD] $ 3.00[/TD]
[TD] $ 1.00[/TD]
[TD]Supplier C[/TD]
[/TR]
[TR]
[TD]Part B[/TD]
[TD] $ 4.00[/TD]
[TD] $ 3.00[/TD]
[TD] $ 1.00[/TD]
[TD]Supplier C[/TD]
[/TR]
[TR]
[TD]Part C[/TD]
[TD] $ 1.00[/TD]
[TD] $ 1.00[/TD]
[TD] $ 3.00[/TD]
[TD]Supplier A[/TD]
[/TR]
</tbody>[/TABLE]

I got the MIN formula, however how do I tye it back to the header row?
Thanks

 

[SawdustCollector]

Enter the following formula in E2 and copy down:

=INDEX($B$1:$D$1,1,MATCH(MIN(B2:D2),B2:D2,0))

 

[rthompson55125]

Enter the following formula in E2 and copy down:

=INDEX($B$1:$D$1,1,MATCH(MIN(B2:D2),B2:D2,0))

WOW! Thank you!

 

[SawdustCollector]

No problem.

 

[rthompson55125]

No problem.

Follow up, what if a cell had $0, how could I exclude that cell from the range?

 

[SawdustCollector]

Try this:

=INDEX($B$1:$D$1,1,MATCH(SMALL(B2:D2,COUNTIF(B2:D2,0)+1),B2:D2,0))

Don't ask me how it works! I got it from here: https://www.extendoffice.com/documents/excel/4033-excel-exclude-zero-from-min.html