Find Lowest Bidder

[Jkulak]

I am trying to find the lowest bid in a range of bids and in an adjacen
cell put the NAME of the bidder in that cell. I can find the lo
bidder using the min function but the lookup functions I'm trying t
use only work if the range is sorted. I don't have this luxury becaus
of the size of the date. Is there a fix for this?

Bidder Joe 1 / Joe 2 / Joe 3 Low Bid / Low Bidder
Bid 36 / 25 / 45 25 / Joe

 

[Bernie Deitrick]

Jkulak,

With bidders in row 1, and bid in row 2:

Lowest Bid:
=MIN(2:2)

Lowest Bidder:
=INDEX(1:1,MATCH(MIN(2:2),2:2,FALSE))

HTH,
Bernie
MS Excel MVP

 

[Jkulak]

Bernie, thank you, it's working beautifully.