Formula to get

[Sky]

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

 

[muddan madhu]

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

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

 

[Sky]

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.

 

[Harlan Grove]

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$1,MATCH(E2,A22,0))