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
|