Need Formula To Identify Lowest Price in Column

[ms10]

I need a formula to identify which vendor has the lowest price for each
item


*Vendor A Vendor B Vendor C*
*Item 1* $10.00 $11.00 $9.00
*Item 2* $20.00 $18.00 $21.00
*Item 3* $4.25 $4.90 $4.65

Thanks / MS


+-------------------------------------------------------------------+
|Filename: ExcelSample.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3520 |
+-------------------------------------------------------------------+

 

[Dave Peterson]

I'm guessing that the vendor names are really in columns B.

I put this in E2 and copied down:
=INDEX($B$1:$D$1,MATCH(MIN($B2:$D2),$B2:$D2,0))

If there's a tie, the leftmost vendor wins.

 

[ms10]

Thank you.. works perfect

I added =INDEX(B22,MATCH(MIN($B2:$D2),$B2:$D2,0)) in F2 so that i can
see the lowest amount

Thanks again / MS