I have a sheet that looks something like this...

Supplier Price Low Price Supplier Low Price
Jimmy's Widgets 10 7
Widget World 45
Widget Discount 7
Widget's R Us 35565

I am able to get "7" to come up as my low price with this function...
=MIN(B2:B5) but I want the name of the corresponding supplier to appear under
"Low Price Supplier". I have tried various combinations of IF, MATCH, etc.
with no success.

Help Please!!

Thanks,

Chris the excel peon