Excel 2007 : How to Get Value from Left Side Cell?

Hello Excel Experts,

I need your advice on my problem.
Lets say I have data product codes and prices from 5 vendors.
(I attached the graphic for better viewer)
I want to get the lowest price from the table. I know how to do it by using formula MIN().
But my problem is I also want to get the product code from the left side the lowest price.
For example:
Row 1: Lowest=0.1 - product code=code1
Row 2: Lowest=1 - product code=code6
Row 3: Lowest=0.2 - product code=code19
Row 4: Lowest=0.15 - product code=code8

I need the data for first and second columns that I marked the header as red in the illustration picture I attached.

What formula should I use to achieve that??
I have tried googling many days, but still have no luck with the formula.
Any helping will be deeply appreciate.

Thanks & Regards,
Agus