Excel Formual Rookie!

[kookie]

Hi,

Excel rookie needing help with an Excel formula!

Need a formula that will show which company has the lowest rate for each product.

Thanks!

PRODUCT	COMPANY A	COMPANY B	COMPANY C	FORMULA??
Product 1	$100	$80	$75	=COMPANY C
Product 2	$200	$215	$180

<tbody>
</tbody>

 

[Michael M]

try

Excel 2007
	A	B	C	D	E
1	PRODUCT	COMPANY A	COMPANY B	COMPANY C	Best Price Company
2	Product 1	$100	$80	$75	COMPANY C
3	Product 2	$200	$150	$180	COMPANY B
Sheet5

Cell Formulas
Range	Formula
E2	=INDEX($B$1:$D$1,MATCH(MIN(B2:D2), B2:D2, 0))
E3	=INDEX($B$1:$D$1,MATCH(MIN(B3:D3), B3:D3, 0))