Using IF to return another cell

[Guest]

To all:

I have a list of bidders and their bids:
Bob Frank Jim
$8 $10 $12

I would like to write a formula that says IF the bid amount is the smallest,
return the name of the bidder (ie "Bob")

Help?

Sincerely,

huber57

 

[JE McGimpsey]

One way:

=INDEX(A1:C1,MATCH(MIN(A2:C2),A2:C2,FALSE))