Spreadsheet: 390117d1429516252-multiple-parameters-using-if-and-vlookup-sample
Sheet: Sheet1

[NAME] | Gender | Rating
50 | Male | Qualitative Rating Here
Participant Result | Participant Sex | [NAME]
Free text Entry | Drop List
Male | < 29 | Female | < 29 |  | Male | 30-39 | Female | 30-39 |  | Male | 40-49 | Female | 40-49 |  | Male | 50-59 | Female | 50-59 |  | Male | 60-69 | Female | 60-69
12 | Poor | 12 | Poor |  | 12 | Poor | 12 | Poor |  | 12 | Poor | 12 | Poor |  | 12 | Poor | 12 | Poor |  | 12 | Poor | 12 | Poor
13 | Poor | 13 | Poor |  | 13 | Poor | 13 | Poor |  | 13 | Poor | 13 | Poor |  | 13 | Poor | 13 | Poor |  | 13 | Poor | 13 | Poor
14 | Poor | 14 | Poor |  | 14 | Poor | 14 | Poor |  | 14 | Poor | 14 | Poor |  | 14 | Poor | 14 | Poor |  | 14 | Poor | 14 | Average
15 | Poor | 15 | Poor |  | 15 | Poor | 15 | Poor |  | 15 | Poor | 15 | Poor |  | 15 | Poor | 15 | Poor |  | 15 | Poor | 15 | Average
16 | Poor | 16 | Poor |  | 16 | Poor | 16 | Poor |  | 16 | Poor | 16 | Poor |  | 16 | Poor | 16 | Average |  | 16 | Average | 16 | Average
17 | Poor | 17 | Poor |  | 17 | Poor | 17 | Poor |  | 17 | Poor | 17 | Average |  | 17 | Poor | 17 | Average |  | 17 | Average | 17 | Average
18 | Poor | 18 | Poor |  | 18 | Poor | 18 | Poor |  | 18 | Poor | 18 | Average |  | 18 | Average | 18 | Average |  | 18 | Average | 18 | Average
19 | Poor | 19 | Poor |  | 19 | Poor | 19 | Poor |  | 19 | Poor | 19 | Average |  | 19 | Average | 19 | Average |  | 19 | Average | 19 | Average
20 | Poor | 20 | Poor |  | 20 | Poor | 20 | Average |  | 20 | Average | 20 | Average |  | 20 | Average | 20 | Average |  | 20 | Average | 20 | Average
21 | Poor | 21 | Poor |  | 21 | Poor | 21 | Average |  | 21 | Average | 21 | Average |  | 21 | Average | 21 | Average |  | 21 | Average | 21 | Good
22 | Poor | 22 | Poor |  | 22 | Poor | 22 | Average |  | 22 | Average | 22 | Average |  | 22 | Average | 22 | Good |  | 22 | Average | 22 | Good
23 | Poor | 23 | Poor |  | 23 | Average | 23 | Average |  | 23 | Average | 23 | Average |  | 23 | Average | 23 | Good |  | 23 | Good | 23 | Good
24 | Poor | 24 | Poor |  | 24 | Average | 24 | Average |  | 24 | Average | 24 | Average |  | 24 | Average | 24 | Good |  | 24 | Good | 24 | Good
25 | Average | 25 | Average |  | 25 | Average | 25 | Average |  | 25 | Average | 25 | Good |  | 25 | Good | 25 | Good |  | 25 | Good | 25 | Good
26 | Average | 26 | Average |  | 26 | Average | 26 | Average |  | 26 | Average | 26 | Good |  | 26 | Good | 26 | Good |  | 26 | Good | 26 | Good
27 | Average | 27 | Average |  | 27 | Average | 27 | Good |  | 27 | Good | 27 | Good |  | 27 | Good | 27 | Good |  | 27 | Good | 27 | Good
28 | Average | 28 | Average |  | 28 | Average | 28 | Good |  | 28 | Good | 28 | Good |  | 28 | Good | 28 | Good |  | 28 | Good | 28 | Good
29 | Average | 29 | Average |  | 29 | Average | 29 | Good |  | 29 | Good | 29 | Good |  | 29 | Good | 29 | Good |  | 29 | Good | 29 | Good
30 | Average | 30 | Average |  | 30 | Average | 30 | Good |  | 30 | Good | 30 | Good |  | 30 | Good | 30 | Good |  | 30 | Good | 30 | Good
31 | Average | 31 | Good |  | 31 | Average | 31 | Good |  | 31 | Good | 31 | Good |  | 31 | Good | 31 | Good |  | 31 | Good | 31 | Good
32 | Average | 32 | Good |  | 32 | Good | 32 | Good |  | 32 | Good | 32 | Good |  | 32 | Good |  | Good |  | 32 | Good | 32 | Good
33 | Average | 33 | Good |  | 33 | Good | 33 | Good |  | 33 | Good | 33 | Good |  | 33 | Good | 33 | Good |  | 33 | Good | 33 | Very Good
34 | Good | 34 | Good |  | 34 | Good | 34 | Good |  | 34 | Good | 34 | Good |  | 34 | Good | 34 | Very Good |  | 34 | Good | 34 | Very Good
35 | Good | 35 | Good |  | 35 | Good | 35 | Good |  | 35 | Good | 35 | Very Good |  | 35 | Good | 35 | Very Good |  | 35 | Good | 35 | Very Good
36 | Good | 36 | Good |  | 36 | Good | 36 | Good |  | 36 | Good | 36 | Very Good |  | 36 | Good | 36 | Very Good |  | 36 | Very Good | 36 | Very Good
37 | Good | 37 | Good |  | 37 | Good | 37 | Very Good |  | 37 | Good | 37 | Very Good |  | 37 | Good | 37 | Very Good |  | 37 | Very Good | 37 | Excellent
38 | Good | 38 | Good |  | 38 | Good | 38 | Very Good |  | 38 | Good | 38 | Very Good |  | 38 | Very Good | 38 | Very Good |  | 38 | Very Good | 38 | Excellent
39 | Good | 39 | Very Good |  | 39 | Good | 39 | Very Good |  | 39 | Very Good | 39 | Very Good |  | 39 | Very Good | 39 | Very Good |  | 39 | Very Good | 39 | Excellent
40 | Good | 40 | Very Good |  | 40 | Good | 40 | Very Good |  | 40 | Very Good | 40 | Very Good |  | 40 | Very Good | 40 | Excellent |  | 40 | Very Good | 40 | Excellent
41 | Good | 41 | Very Good |  | 41 | Good | 41 | Very Good |  | 41 | Very Good | 41 | Very Good |  | 41 | Very Good | 41 | Excellent |  | 41 | Excellent | 41 | Excellent
42 | Good | 42 | Very Good |  | 42 | Good | 42 | Excellent |  | 42 | Very Good | 42 | Excellent |  | 42 | Very Good | 42 | Excellent |  | 42 | Excellent | 42 | Excellent
43 | Good | 43 | Very Good |  | 43 | Very Good | 43 | Excellent |  | 43 | Very Good | 43 | Excellent |  | 43 | Excellent | 43 | Excellent |  | 43 | Excellent | 43 | Excellent
44 | Very Good | 44 | Very Good |  | 44 | Very Good | 44 | Excellent |  | 44 | Very Good | 44 | Excellent |  | 44 | Excellent | 44 | Excellent |  | 44 | Excellent | 44 | Excellent
45 | Very Good | 45 | Very Good |  | 45 | Very Good | 45 | Excellent |  | 45 | Excellent | 45 | Excellent |  | 45 | Excellent | 45 | Excellent |  | 45 | Excellent | 45 | Excellent
46 | Very Good | 46 | Very Good |  | 46 | Very Good | 46 | Excellent |  | 46 | Excellent | 46 | Excellent |  | 46 | Excellent | 46 | Excellent |  | 46 | Excellent | 46 | Excellent
47 | Very Good | 47 | Very Good |  | 47 | Very Good | 47 | Excellent |  | 47 | Excellent | 47 | Excellent |  | 47 | Excellent | 47 | Excellent |  | 47 | Excellent | 47 | Excellent
48 | Very Good | 48 | Very Good |  | 48 | Very Good | 48 | Excellent |  | 48 | Excellent | 48 | Excellent |  | 48 | Excellent | 48 | Excellent |  | 48 | Excellent | 48 | Excellent
49 | Very Good | 49 | Very Good |  | 49 | Very Good | 49 | Excellent |  | 49 | Excellent | 49 | Excellent |  | 49 | Excellent | 49 | Excellent |  | 49 | Excellent | 49 | Excellent
50 | Very Good | 50 | Excellent |  | 50 | Very Good | 50 | Excellent |  | 50 | Excellent | 50 | Excellent |  | 50 | Excellent | 50 | Excellent |  | 50 | Excellent | 50 | Excellent
51 | Very Good | 51 | Excellent |  | 51 | Excellent | 51 | Excellent |  | 51 | Excellent | 51 | Excellent |  | 51 | Excellent | 51 | Excellent |  | 51 | Excellent | 51 | Excellent
52 | Very Good | 52 | Excellent |  | 52 | Excellent | 52 | Excellent |  | 52 | Excellent | 52 | Excellent |  | 52 | Excellent | 52 | Excellent |  | 52 | Excellent | 52 | Excellent
53 | Excellent | 53 | Excellent |  | 53 | Excellent | 53 | Excellent |  | 53 | Excellent | 53 | Excellent |  | 53 | Excellent | 53 | Excellent |  | 53 | Excellent | 53 | Excellent