Max and min odds lookup

[andyh]

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