Hi,
I think I need an index match formula for my problem but I cant get my head around it.
Hopefully someone can help me out.
I want to populate L6 with a formula in the race sheet with the the corresponding time in the course sheet, then copy it down to fill the rest of L.
The answer would be 95.8 which is SANL/1600/Good on the race sheet.

IM.jpg
IM1.jpg