In the attached spreadsheet, I used MATCH(). Hope it does what you
want.
lawdoggy Wrote:
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
+-------------------------------------------------------------------+
|Filename: Physical.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3696 |
+-------------------------------------------------------------------+
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=396266