Formula to get the Ans
 

Hi,

Supplier
A B C D Min Cost Column for Ans
1 $1.00 $2.00 $3.00 $4.00 $1.00 Supplier A
2 $2.00 $1.00 $3.00 $4.00 $1.00 Supplier B
3 $5.00 $6.00 $7.00 $8.00 $5.00 Supplier A
4 $8.00 $7.00 $5.00 $6.00 $5.00 Supplier C
5 $7.00 $6.00 $5.00 $4.00 $4.00 Supplier D

Could anyone help to advice on the formula to get the ans on the "Column for
Ans"

Formula to get the Ans
 

Assuming that column E has the minimum, then in F1 enterr:

="Supplier " & CHOOSE(MATCH(E1,A1:D1),"A","B","C","D")
and copy down
--
Gary''s Student - gsnu200850


"Sky" wrote:

Hi,

Supplier
A B C D Min Cost Column for Ans
1 $1.00 $2.00 $3.00 $4.00 $1.00 Supplier A
2 $2.00 $1.00 $3.00 $4.00 $1.00 Supplier B
3 $5.00 $6.00 $7.00 $8.00 $5.00 Supplier A
4 $8.00 $7.00 $5.00 $6.00 $5.00 Supplier C
5 $7.00 $6.00 $5.00 $4.00 $4.00 Supplier D

Could anyone help to advice on the formula to get the ans on the "Column for
Ans"

Formula to get the Ans
 

Hi

="Supplier "&INDEX($A$1:$D$1,MATCH(E2,A2:D2,0))

--
Regards
Roger Govier

"Sky" wrote in message
...
Hi,

Supplier
A B C D Min Cost Column for Ans
1 $1.00 $2.00 $3.00 $4.00 $1.00 Supplier A
2 $2.00 $1.00 $3.00 $4.00 $1.00 Supplier B
3 $5.00 $6.00 $7.00 $8.00 $5.00 Supplier A
4 $8.00 $7.00 $5.00 $6.00 $5.00 Supplier C
5 $7.00 $6.00 $5.00 $4.00 $4.00 Supplier D

Could anyone help to advice on the formula to get the ans on the "Column
for
Ans"

Formula to get the Ans
 

Thanks Gary,

Can only get 1 to 3 but 4 and 5 under Supplier C and cannot get

"Gary''s Student" wrote:

Assuming that column E has the minimum, then in F1 enterr:

="Supplier " & CHOOSE(MATCH(E1,A1:D1),"A","B","C","D")
and copy down
--
Gary''s Student - gsnu200850


"Sky" wrote:

Hi,

Supplier
A B C D Min Cost Column for Ans
1 $1.00 $2.00 $3.00 $4.00 $1.00 Supplier A
2 $2.00 $1.00 $3.00 $4.00 $1.00 Supplier B
3 $5.00 $6.00 $7.00 $8.00 $5.00 Supplier A
4 $8.00 $7.00 $5.00 $6.00 $5.00 Supplier C
5 $7.00 $6.00 $5.00 $4.00 $4.00 Supplier D

Could anyone help to advice on the formula to get the ans on the "Column for
Ans"

Formula to get the Ans
 

Here is the correction:

="Supplier " & CHOOSE(MATCH(E1,A1:D1,0),"A","B","C","D")

--
Gary''s Student - gsnu200850


"Sky" wrote:

Thanks Gary,

Can only get 1 to 3 but 4 and 5 under Supplier C and cannot get

"Gary''s Student" wrote:

Assuming that column E has the minimum, then in F1 enterr:

="Supplier " & CHOOSE(MATCH(E1,A1:D1),"A","B","C","D")
and copy down
--
Gary''s Student - gsnu200850


"Sky" wrote:

Hi,

Supplier
A B C D Min Cost Column for Ans
1 $1.00 $2.00 $3.00 $4.00 $1.00 Supplier A
2 $2.00 $1.00 $3.00 $4.00 $1.00 Supplier B
3 $5.00 $6.00 $7.00 $8.00 $5.00 Supplier A
4 $8.00 $7.00 $5.00 $6.00 $5.00 Supplier C
5 $7.00 $6.00 $5.00 $4.00 $4.00 Supplier D

Could anyone help to advice on the formula to get the ans on the "Column for
Ans"