Using IF to return another cell
 

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

Using IF to return another cell
 

One way:

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

In article ,
Huber57 wrote:

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