Spreadsheet: 54376d1254356626-problem-with-hlookup-vlookup-index-with-table-701582-close-answers
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-10-01 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 | 1976-04-03 00:00:00 | 33 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 33
23 | M |  | [NAME] | E-7 | 1933-04-03 00:00:00 | 76 |  |  | 55 | 100 |  |  |  |  |  | 0 | 0 | 0 | 0 | 76
24 | M |  | [NAME] |  | 1976-04-03 00:00:00 | 33 | 2009-10-01 00:00:00 |  | 55 | 79 |  |  |  |  |  | 0 | 0 | 0 | 0 | 33
25 | f |  | [NAME] | [NAME] | 1962-05-19 00:00:00 | 47 |  |  | 22 | 80 |  |  |  |  |  | 0 | 0 | 0 | 0 | 47
26 | M |  |  | E-5 |  | 109 |  |  |  | #N/A |  |  |  |  |  | 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