Yes, difficult to solve without a sample, but....something like this?


=VLOOKUP(2,INDIRECT("B"&MATCH("Race 2",A:A,0)&":"&"H"&MATCH("Race 2",A:A,1)),7,FALSE)

Where the 2 after the VLOOKUP is the horse number you're looking for and "Race 2" is the name of the race that you're after.