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