Formula help
 

Hi i have made an excel programme for horse race nights, which handles the
betting and prints out the betting slip with the race number and horse name
on it, there are 8 races in a night so i want to be able to select say Race
one in a cell and it will put the horses name into the printout, the horses
are all listed on another work sheet

Mike