Spreadsheet: 54373d1254353702-problem-with-hlookup-vlookup-index-with-table-apft
Sheet: APFT

 |  | Last Name | First Name | Rank | DOB | AGE | APFT Date | PU | RAW | SU | RAW | 2Mi Run | RAW | 2.5  Walk | Total Score | PU | SU | 2 ML | 2009-09-30 00:00:00
1 | M |  |  | O-3 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
2 | F |  |  | E-6 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
3 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
4 | F |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
5 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
6 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
7 | M |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
8 | M |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
9 | F |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
10 | F |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
11 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
12 | F |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
13 | F |  |  | E-6 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
14 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
15 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
16 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
17 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
18 | M |  |  | E-6 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
19 | F |  |  | E-6 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
20 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
21 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
22 | F |  |  | E-6 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
23 | M |  |  | E-7 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
24 | M |  | [NAME] |  | 1976-04-03 00:00:00 | 33 | 2009-09-30 00:00:00 |  | 55 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 33
25 | M |  |  | [NAME] |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
26 | M |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
27 | M |  |  | O-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
28 | M |  |  | E-1 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
29 | M |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
30 | M |  |  | E-6 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
31 | M |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
32 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
33 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
34 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
35 | M |  |  | E-7 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
36 | M |  |  | O-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
37 | F |  |  | O-3 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
38 | M |  |  | E-6 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
39 | M |  |  | O-3 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
40 | F |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
41 | F |  |  | O-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
42 | M |  |  | E-3 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
43 | M |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
44 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
45 | M |  |  | O-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
46 | F |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
47 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
48 | M |  |  | E-4 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
49 | F |  |  | E-5 |  | 109 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 109
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PASSED TOTAL |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PERS. TOTAL |  | 49 | 49 | 49 | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PERCENTAGE |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PU | SU | 2 MI | ALL