Find Lowest Bidder
 

I am trying to find the lowest bid in a range of bids and in an adjacent
cell put the NAME of the bidder in that cell. I can find the low
bidder using the min function but the lookup functions I'm trying to
use only work if the range is sorted. I don't have this luxury because
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 / Joe2


--
Jkulak
------------------------------------------------------------------------
Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
View this thread: http://www.excelforum.com/showthread...hreadid=394636

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" wrote in message
...

I am trying to find the lowest bid in a range of bids and in an adjacent
cell put the NAME of the bidder in that cell. I can find the low
bidder using the min function but the lookup functions I'm trying to
use only work if the range is sorted. I don't have this luxury because
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 / Joe2


--
Jkulak
------------------------------------------------------------------------
Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
View this thread: http://www.excelforum.com/showthread...hreadid=394636

Bernie, thank you, it's working beautifully. J


--
Jkulak
------------------------------------------------------------------------
Jkulak's Profile: http://www.excelforum.com/member.php...o&userid=26135
View this thread: http://www.excelforum.com/showthread...hreadid=394636