View Single Post
  #6  
Old 17th June 2005, 01:37 PM
laish laish is offline
Member
 
Join Date: Jan 1970
Posts: 31
Smile We're gettin there

OK, now try this.

1 horse 1 horse 1
2 horse 2 =VLOOKUP(SMALL(A3:A6,1),A3:B6,2)
3 horse 3
4 horse 4

Where col 1 is th price, 2 is the horse name or other data.The horse1 in col 3 is the answer to th question below of which value is the horse name when th value of col 1 is the lowest price. If this makes sense if this also may help.
Reply With Quote