lookup with paramaters

[tlindeman]

I have a list of my running times on sheet, "WORKOUT" and then a list of times for the actual race on "half marathon" What I would like to do is lookup my time on my workout and find what place I would have been in on half marathon. Obviously my time will not correspond exaclty so I can't use vlookup. For eaxample, my time was 11:08:13 and on the half marathon this falls exactly between 221 and 222. Is there a way to do this?

Thank You
Tony

 

[SydneyGeek]

You can use MATCH.
Say your time is in B3, and the half-marathon times are (sorted) from D2:D2500.
=MATCH(B3,D2:D2500,1) will give the position of the person who just beat you.
=MATCH(B3,D2:D2500,-1) will give the position of the person who you just beat.

Denis