Creating a Bid Sheet need to pick lowest Bidder

Quick example:

I have

PHP Code: 


           #1                             #2                            #3
quanity  unit price  total        quanity  unit price  total       quanity  unit price  total
2           10            20           3           10           30            5          10         50
5           10            50           4           10           40            2          10         20 
6           10            60           7           10           70            1          10         10

          subtotal      130                   subtotal      140                 subtotal        80 


I would like to copy the unit price (Entire Column) from the lowest bider (Subtotal) to another sheet ... I have done this with if statements before but I'm limited to 7 nested if's... is there another way to do this sometimes I have more ten 7 bidders.

Thanx once more...