by andyh » Sat Jun 16, 2007 6:43 pm
For a while now I have been using two sheets in excel, one with a list of horses(sheet 2) and the sheet 1 triggering the bets. I have used the line below to lookup the odds from sheet 2 and so then inserted into sheet one -
=IF(ISNA(VLOOKUP(A5,Sheet2!$A$1:$C$100,2,FALSE)),"No bet",VLOOKUP(A5,Sheet2!$A$1:$C$100,2,FALSE) )
The trigger then looks to this column using this statement-
=IF(R5="No Bet","",IF(AND(H5>=2,H5<=12,$A$40<0.0166),"LAY","WAIT") )
Then I started wondering is it possible to create a maximum and minimum odds column in sheet two and to only have the trigger act if the current lay odds fall within this range. I have tried various plans but don't really have enough experience to get this together myself. I ended up in a right muddle with VLOOKUPS everywhere! Any help or direction would be greatly appreciated.
Andy