VLookup

[David]

Having problems with the VLookup function.
I have a worksheet 1 with the following :
COURSE Dist Stime
Epsom 5f 55.40
Epsom 6f 69.40
Goodwood 5f 57.80
Goodwood 6f 71.30
Hamilton 5f 58.60
Hamilton 1m65yds106.10
On my main worksheet I have tried to fill in the Stime
column with the VLookup function but it only works on
the first entry of each Course.ie: 55.40,57.80 and 58.60.
Example of function:- VLookup(sheet1!$A$2:$C$7,3,0)this
is only a small sample of the actual worksheet 1.
I hope someone can help.

 

[Earl Kiosterud]

David,

The VLOOKUP appears to be doing what it's supposed to do. It finds the
first match, and returns the third cell over. A VLOOKUP can only return one
value, and doesn't know if other VLOOKUPs have already returned a value for
a row for that particular course,