Hi,
Supplier
A B C D Min Cost 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 and advice me is there any fomula to get on the column
indicate Ans.
The Ans is indicate as per below
Supplier A
Supplier B
Supplier A
Supplier C
Supplier D

To get minimum value use this formula =MIN(A2:D2) in cell E2 and drag
it down

to get supplier name put this in cell F2 ="Supplier "&LOOKUP
(E2,A2:D2,$A$1:$D$1) and drag it down.



On May 1, 3:06*pm, Sky wrote:
Hi,
* * * * Supplier * * * * * * * * * * * * * * * * * * * *
* * * * A * * * B * * * C * * * D * * * Min Cost * * * *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 and advice me is there any fomula to get on the column
indicate Ans.
The Ans is indicate *as per below
Supplier A
Supplier B
Supplier A
Supplier C
Supplier D

Thanks Madhu.

For 1 to 3 I could get the supplier A and B but for 4 and 5 is under
SupplierC and D I cannot get.

"muddan madhu" wrote:

To get minimum value use this formula =MIN(A2:D2) in cell E2 and drag
it down

to get supplier name put this in cell F2 ="Supplier "&LOOKUP
(E2,A2:D2,$A$1:$D$1) and drag it down.



On May 1, 3:06 pm, Sky wrote:
Hi,
Supplier
A B C D Min Cost 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 and advice me is there any fomula to get on the column
indicate Ans.
The Ans is indicate as per below
Supplier A
Supplier B
Supplier A
Supplier C
Supplier D

Sky wrote...
For 1 to 3 I could get the supplier A and B but for 4 and 5 is under
SupplierC and D I cannot get. *
....

LOOKUP *requires* that its lookup row or column be in ascending order.
It can fail when its lookup row or column is unsorted, as is the case
with your sample data.

Try

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