I'm creating a spreadie to record TT results on, for my different events.
I want to compare my time against the winner of that event. easy enough.
but, I want to compare my times against my PB for a course, and my PB for a distance. so i have the columns:
course (for example M21)
then the columns
time difference - Course PB
time difference - Distance PB
so, how would i search the columns to find the PB for a given course, or distance, and then compare the time field against it? I thought vlookup, but I don;t think that will do the job, as it doesn't look to be dynamic. any ideas?