VLOOKUP et al

[boycee]

I am wrestling with the VLOOKUP function in Excel. I want to use it for automating my selections on the dogs. the problem is that on Betfair trap numbers are used instead of discreet names. To cut along story short here is an example of my problem:-

Race 1 Trap 1
Race 2 Trap 2
Race 2 Trap 3
Race 2 Trap 6
Race 3 Trap 4
Race 4 Trap 1
Race 4 Trap 2
Race 6 Trap 1

etc etc

When I use the VLOOKUP function I can get it to return single values for each race. How do I get it to return all of the positive values for each race.

eg if I use VLOOKUP for RACE 2 I only get Trap 2 instead of Traps 2 , 3 and 6

This is the first time I have used this function and it is doing my head in!

[Captain Sensible]

I posted some VLOOKUP code under

http://gruss-software.co.uk/forum/viewt ... c&start=15

that may be of use to you - It basically picks a horse from a list.

As you'd have lots of runners with the same name you'll need to add a separate field with the race time to filter .

I'd do it the same way as on the other thread just use the race time to populate part of the VLOOKUP

i.e. column A race time (format this coumn as text) Column B Trap 1 etc Column C use to populate this with the TRAP #'s when the race time is hit Column D odds column E stake Column F BACK/LAY

So VLOOKUP would use column C but that would only be populated with the traps when the race time had been hit
Just stick the race time in a named cell say 'time' then for column C just use a simple statement like
=IF(A1=time,B1,"") Then if it the correct time that column would fill with your runners to pick using VLOOKUP. Alot harder to try and explain than actually do it

[boycee]

Worked a treat Capt.

Many thanks.

Will try it out in anger today mate.