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