
17th June 2005, 01:37 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 31
|
|
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.
|