Fill in a cell based on an answer from another range

Pair MATCH with INDEX: MATCH finds which column holds the lowest price, and INDEX returns the name from the same column one row down. With the prices in B1:K1 and the names in B2:K2 on a tab called Bids (swap in your own range and tab name):

=INDEX(Bids!B2:K2,MATCH(MIN(Bids!B1:K1),Bids!B1:K1,0))

On Excel 365 or Excel 2021 and later, XLOOKUP does the same in one step:

=XLOOKUP(MIN(Bids!B1:K1),Bids!B1:K1,Bids!B2:K2)

Both give the first contractor if two bids tie for the lowest price. To list every tied contractor in one cell (Excel 365 or 2021 and later):

=TEXTJOIN(", ",TRUE,FILTER(Bids!B2:K2,Bids!B1:K1=MIN(Bids!B1:K1)))

Keep the price and name ranges the same width, and keep the 0 at the end of MATCH so it only takes an exact match. A trade with an empty bid cell still works, since MIN skips blanks.

(Drafted with AI assistance; formulas tested before posting.)