Betting pre-determined selections before the off

[MiniBlueDragon]

Hi folks. Am I correct in assuming the easiest way to back pre-determined selections just prior to the off is to create an Excel sheet with them on and use a simple IF statement, e.g. a sheet names "runners" and a formula like:

Code: Select all

=MATCH(Y5,Runners!$A$1:$A$50,0)

And wrap an error catch around it to produce a blank cell if the runner isn't in the Runners list:

Code: Select all

=IF(ISNA(MATCH(Y5,Runners!$A$1:$A$50,0)),"",MATCH(Y5,Runners!$A$1:$A$50,0))

Then the trigger would simply be:

=IF(AN5<>"","BACK-IP","")

[Captain Sensible]

There's an example sheet here http://www.gruss-software.co.uk/Excel/E ... etting.htm

Think a few people have used it as a starting point. Looks messy with the all the #NA errors but to be honest unless you're OCD sometimes it's not worth the effort tarting things up with bots