Spreadsheet: 770985d1646370070-vlookup-returns-n-a-possibly-searching-function-instead-of-result-spelling-ages-test-sheet
Sheet: Data

Form A |  |  | Form B |  |  | Form A |  |  |  |  | Form B
Score | Age |  | Score | Age |  | Age | Average | Normal | Critical |  | Age | Average | Normal | Critical
12 | <6 |  | 12 | <6 |  | 6 | 14 | 8-20 | 4
13 | 6 |  | 13 | 6.1 |  | 6.1 | 15 | 9-21 | 5
14 | 6.1 |  | 14 | 6.2 |  | 6.2 | 15 | 9-21 | 5
15 | 6.2 |  | 15 | 6.3 |  | 6.3 | 16 | 10-22 | 6
16 | 6.3 |  | 16 | 6.4 |  | 6.4 | 16 | 10-22 | 6
17 | 6.4 |  | 17 | 6.6 |  | 6.5 | 17 | 11-23 | 7
18 | 6.5 |  | 18 | 6.7 |  | 6.6 | 18 | 12-24 | 8
19 | 6.6 |  | 19 | 6.9 |  | 6.7 | 18 | 12-24 | 8
20 | 6.7 |  | 20 | 6.1 |  | 6.8 | 19 | 13-25 | 9
21 | 6.8 |  | 21 | 7 |  | 6.9 | 19 | 13-25 | 9
22 | 6.1 |  | 22 | 7.1 |  | 6.11 | 21 | 15-27 | 11
23 | 6.11 |  | 23 | 7.2 |  | 7 | 22 | 16-28 | 12
24 | 7.1 |  | 24 | 7.4 |  | 7.1 | 22 | 16-28 | 12
25 | 7.2 |  | 25 | 7.5 |  | 7.2 | 23 | 17-29 | 13
26 | 7.4 |  | 26 | 7.6 |  | 7.3 | 23 | 17-29 | 13
27 | 7.6 |  | 27 | 7.8 |  | 7.4 | 24 | 18-30 | 14
28 | 7.8 |  | 28 | 7.1 |  | 7.5 | 24 | 18-30 | 14
29 | 7.11 |  | 29 | 8.1 |  | 7.6 | 25 | 19-31 | 15
30 | 8.1 |  | 30 | 8.2 |  | 7.7 | 25 | 19-31 | 15
31 | 8.4 |  | 31 | 8.4 |  | 7.8 | 26 | 20-32 | 16
32 | 8.7 |  | 32 | 8.6 |  | 7.9 | 27 | 21-33 | 17
33 | 8.1 |  | 33 | 8.8 |  | 7.11 | 28 | 22-34 | 18
34 | 8.11 |  | 34 | 8.11 |  | 8 | 28 | 22-34 | 18
35 | 9.1 |  | 35 | 9.1 |  | 8.1 | 29 | 23-35 | 19
36 | 9.4 |  | 36 | 9.3 |  | 8.2 | 29 | 23-35 | 19
37 | 9.6 |  | 37 | 9.5 |  | 8.3 | 30 | 24-36 | 20
38 | 9.11 |  | 38 | 9.6 |  | 8.4 | 30 | 24-36 | 20
39 | 10.2 |  | 39 | 9.9 |  | 8.5 | 31 | 25-37 | 21
40 | 10.5 |  | 40 | 10 |  | 8.6 | 31 | 25-37 | 21
41 | 10.8 |  | 41 | 10.3 |  | 8.7 | 31 | 25-37 | 21
42 | 10.11 |  | 42 | 10.5 |  | 8.8 | 32 | 26-37 | 22
43 | 11.2 |  | 43 | 10.8 |  | 8.9 | 32 | 26-37 | 22
44 | 11.1 |  | 44 | 10.1 |  | 8.11 | 33 | 27-39 | 23
45 | 12.2 |  | 45 | 11 |  | 9 | 33 | 27-39 | 23
46 | 12.5 |  | 46 | 11.2 |  | 9.1 | 33 | 27-39 | 23
47 | 12.8 |  | 47 | 11.4 |  | 9.2 | 34 | 28-40 | 24
48 | 13 |  | 48 | 11.7 |  | 9.3 | 34 | 28-40 | 24
49 | 13.5 |  | 49 | 11.11 |  | 9.4 | 35 | 29-41 | 25
50 | 13.1 |  | 50 | 12.3 |  | 9.5 | 35 | 29-41 | 25
51 | 14.4 |  | 51 | 12.5 |  | 9.6 | 35 | 29-41 | 25
52 | 14.11 |  | 52 | 12.1 |  | 9.7 | 36 | 30-42 | 26
53 | 15.7 |  | 53 | 13.2 |  | 9.8 | 36 | 30-42 | 26
54 | 16+ |  | 54 | 13.8 |  | 9.9 | 36 | 30-42 | 26
 |  |  | 55 | 14.5 |  | 9.11 | 37 | 31-43 | 27
 |  |  | 56 | 15.2 |  | 10 | 37 | 31-43 | 27
 |  |  | 57 | 15.9 |  | 10.1 | 37 | 31-43 | 27
 |  |  | 58 | 16+ |  | 10.2 | 38 | 32-44 | 28
 |  |  |  |  |  | 10.3 | 38 | 32-44 | 28
 |  |  |  |  |  | 10.4 | 38 | 32-44 | 28
 |  |  |  |  |  | 10.5 | 39 | 33-44 | 29
 |  |  |  |  |  | 10.6 | 39 | 33-44 | 29
 |  |  |  |  |  | 10.7 | 40 | 35-45 | 30
 |  |  |  |  |  | 10.8 | 40 | 35-45 | 30
 |  |  |  |  |  | 10.9 | 40 | 35-45 | 30
 |  |  |  |  |  | 10.11 | 41 | 35-47 | 31
 |  |  |  |  |  | 11 | 41 | 35-47 | 31
 |  |  |  |  |  | 11.1 | 42 | 36-48 | 32
 |  |  |  |  |  | 11.2 | 42 | 36-48 | 32
 |  |  |  |  |  | 11.3 | 42 | 36-48 | 32
 |  |  |  |  |  | 11.4 | 43 | 39-49 | 33
 |  |  |  |  |  | 11.5 | 43 | 39-49 | 33
 |  |  |  |  |  | 11.6 | 44 | 38-50 | 34
 |  |  |  |  |  | 11.7 | 44 | 38-50 | 34
 |  |  |  |  |  | 11.8 | 44 | 38-50 | 34
 |  |  |  |  |  | 11.9 | 44 | 38-50 | 34
 |  |  |  |  |  | 11.11 | 45 | 39-51 | 35
 |  |  |  |  |  | 12 | 45 | 39-51 | 35
 |  |  |  |  |  | 12.1 | 46 | 40-52 | 36
 |  |  |  |  |  | 12.2 | 46 | 40-52 | 36
 |  |  |  |  |  | 12.3 | 46 | 40-52 | 36
 |  |  |  |  |  | 12.4 | 47 | 40-54 | 37
 |  |  |  |  |  | 12.5 | 47 | 40-54 | 37
 |  |  |  |  |  | 12.6 | 47 | 40-54 | 37
 |  |  |  |  |  | 12.7 | 47 | 40-54 | 37
 |  |  |  |  |  | 12.8 | 48 | 41-55 | 38
 |  |  |  |  |  | 12.9 | 48 | 41-55 | 38
 |  |  |  |  |  | 12.11 | 48 | 41-55 | 38
 |  |  |  |  |  | 13 | 48 | 41-55 | 38
 |  |  |  |  |  | 13.1 | 48 | 41-55 | 38
 |  |  |  |  |  | 13.2 | 48 | 41-55 | 38
 |  |  |  |  |  | 13.3 | 48 | 41-55 | 38
 |  |  |  |  |  | 13.4 | 48 | 41-55 | 38
 |  |  |  |  |  | 13.5 | 48 | 41-55 | 38
 |  |  |  |  |  | 13.6 | 48 | 41-55 | 38
 |  |  |  |  |  | 13.7 | 49 | 42-56 | 39
 |  |  |  |  |  | 13.8 | 49 | 42-56 | 39
 |  |  |  |  |  | 13.9 | 49 | 42-56 | 39
 |  |  |  |  |  | 13.11 | 50 | 43-57 | 40
 |  |  |  |  |  | 14 | 50 | 43-57 | 40
 |  |  |  |  |  | 14.1 | 50 | 43-57 | 40
 |  |  |  |  |  | 14.2 | 50 | 43-57 | 40
 |  |  |  |  |  | 14.3 | 50 | 43-57 | 40
 |  |  |  |  |  | 14.4 | 51 | 45-57 | 41
 |  |  |  |  |  | 14.5 | 51 | 45-57 | 41
 |  |  |  |  |  | 14.6 | 51 | 45-57 | 41
 |  |  |  |  |  | 14.7 | 51 | 45-57 | 41
 |  |  |  |  |  | 14.8 | 51 | 45-57 | 41
 |  |  |  |  |  | 14.9 | 51 | 45-57 | 41
 |  |  |  |  |  | 14.11 | 52 | 46-58 | 42
 |  |  |  |  |  | 15 | 52 | 46-58 | 42
 |  |  |  |  |  | 15.1 | 52 | 46-58 | 42
 |  |  |  |  |  | 15.2 | 52 | 46-58 | 42
 |  |  |  |  |  | 15.3 | 52 | 46-58 | 42
 |  |  |  |  |  | 15.4 | 52 | 46-58 | 42
 |  |  |  |  |  | 15.5 | 52 | 46-58 | 42
 |  |  |  |  |  | 15.6 | 52 | 46-58 | 42