Help with a Lookup

[MollyElizabeth]

I get daily bids from different vendors for a commodity. In the column out to the right I want to put the daily minimum bid (got that part figured out) and the vendor with the lowest bid. I have tried to use the lookup function, but because the bids will never be in ascending order that function will not work. Here an example of my spreadsheet. So for 1/2/2015 I would like to see Company E returned as the lowest bidder in the far right column.

[TABLE="width: 1070"]
<colgroup><col><col><col><col span="2"><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Company A[/TD]
[TD]Company B[/TD]
[TD]Company C[/TD]
[TD]Company D[/TD]
[TD]Company E[/TD]
[TD]Company F[/TD]
[TD]Lowest Bid[/TD]
[TD]Vendor[/TD]
[/TR]
[TR]
[TD]01/02/15[/TD]
[TD]No Bid[/TD]
[TD]$2.0170[/TD]
[TD]$2.0100[/TD]
[TD]$2.1143[/TD]
[TD]$1.9256[/TD]
[TD]$2.1043[/TD]
[TD]$1.9256[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/05/15[/TD]
[TD]$1.9835[/TD]
[TD]$2.0275[/TD]
[TD]$2.0111[/TD]
[TD]$1.9906[/TD]
[TD]$2.1211[/TD]
[TD]$1.9488[/TD]
[TD]$1.9488[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/06/15[/TD]
[TD]No Bid[/TD]
[TD]$2.0040[/TD]
[TD]$1.9695[/TD]
[TD]$1.9956[/TD]
[TD]$2.1050[/TD]
[TD]No Bid[/TD]
[TD]$1.9695[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/07/15[/TD]
[TD]$2.1111[/TD]
[TD]No Bid[/TD]
[TD]$2.0100[/TD]
[TD]No Bid[/TD]
[TD]$1.9545[/TD]
[TD]No Bid[/TD]
[TD]$1.9545[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/08/15[/TD]
[TD]$2.1143[/TD]
[TD]$2.1175[/TD]
[TD]$2.1192[/TD]
[TD]$2.1211[/TD]
[TD]$1.9547[/TD]
[TD]$2.1111[/TD]
[TD]$1.9547[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/09/15[/TD]
[TD]$2.1043[/TD]
[TD]$2.1050[/TD]
[TD]$2.1181[/TD]
[TD]No Bid[/TD]
[TD]$2.0170[/TD]
[TD]$1.9385[/TD]
[TD]$1.9385[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/12/15[/TD]
[TD]$1.9952[/TD]
[TD]No Bid[/TD]
[TD]No Bid[/TD]
[TD]No Bid[/TD]
[TD]No Bid[/TD]
[TD]$1.9995[/TD]
[TD]$1.9952[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/13/15[/TD]
[TD]$2.0275[/TD]
[TD]$2.0890[/TD]
[TD]$1.8922[/TD]
[TD]$2.0055[/TD]
[TD]No Bid[/TD]
[TD]$2.0111[/TD]
[TD]$1.8922[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/14/15[/TD]
[TD]$1.9620[/TD]
[TD]$2.0055[/TD]
[TD]$2.1175[/TD]
[TD]No Bid[/TD]
[TD]$1.9886[/TD]
[TD]$1.9883[/TD]
[TD]$1.9620[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/15/15[/TD]
[TD]$1.9937[/TD]
[TD]$1.8995[/TD]
[TD]$2.0045[/TD]
[TD]$2.0040[/TD]
[TD]$1.9382[/TD]
[TD]$1.9956[/TD]
[TD]$1.8995[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/16/15[/TD]
[TD]No Bid[/TD]
[TD]$2.0040[/TD]
[TD]$1.9695[/TD]
[TD]$1.9956[/TD]
[TD]$2.1050[/TD]
[TD]No Bid[/TD]
[TD]$1.9695[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/20/15[/TD]
[TD]$2.1111[/TD]
[TD]No Bid[/TD]
[TD]$2.0100[/TD]
[TD]No Bid[/TD]
[TD]$1.9545[/TD]
[TD]No Bid[/TD]
[TD]$1.9545[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/21/15[/TD]
[TD]$1.8922[/TD]
[TD]$2.0055[/TD]
[TD]No Bid[/TD]
[TD]$2.0111[/TD]
[TD]No Bid[/TD]
[TD]No Bid[/TD]
[TD]$1.8922[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01/22/15[/TD]
[TD]$2.1175[/TD]
[TD]No Bid[/TD]
[TD]$1.9886[/TD]
[TD]$1.9883[/TD]
[TD]No Bid[/TD]
[TD]$1.9090[/TD]
[TD]$1.9090[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

If that table you posted begins in A1 (The word DATE appears in A1)
Try this in I2

=INDEX(B$1:H$1,MATCH(MIN(B2:H2),B2:H2,0))

 

[MollyElizabeth]

Perfect! Thank you!!!!

 

[Jonmo1]

You're welcome.