by toyboydave » Thu Mar 15, 2012 5:14 am
Hi there
I am using Gary's sample excel sheet 'Place bets on a selection of horses.' In the 'Market' sheet, when a selection is matched, it is shown in the same row as it appears on the Betfair listing for the race, i.e. if it was the favourite it would be on row 5. However, in the Selections sheet, the horse may be 20th on the list. I need the odds from my selection on the Market sheet to be on the same row as the selection on the Selection sheet so that stake can be calculated automatically. I've tried various lookup sequences but to no avail. Any ideas please. Thanks.
Toyboydave