Hello...i'm in charge of conducting a physical training test and have a
table already created with the parameters of the test. Here is a
partial table:

% 1.5 mile 300m Bench sit-ups push vertical
99 9:52 42 1.72 62 72 30
95 10:34 48 1.40 50 60 25.5
90 11:20 50 1.30 47 51 24
85 11:55 52 1.18 45 50 22
80 12:30 53 1.11 43 44 21.5
75 12:56 54 1.04 42 41 21


what i would like to do is put in everyone's scores and have excel
check this table to tell me what percentage they received for that
score. i have been trying vlookup without success. i'm not sure how the
proper syntax would be to say:

Smith ran the 1.5 mile in 10 minutes 05 seconds. now this value in the
above table is between 99% and 95%. do i use vlook up for this? the
correct answer is 95% because the value falls to if the better one is
not reached.

any help would be greatly appeciated!

thanks...mitch