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