12 =VLOOKUP(C2,$P$2:$Q$7,1) A B C D E F G K Y Y Binary Age Gender BMI BP Total Chol LDL HDL TCH LTG Glucose M Age Category N 0 P Q Category Age Group 2 151 Low 59 2 32.1 101 157 93.2 38 4 4.8598 87 6 3 75 Low 48 1 21.6 87 183 103.2 70 3 3.8918 69 141 Low 72 2 30.5 93 156 93.6 41 4 4.6728 85 5 206 High 24 1 25.3 84 198 131.4 40 5 4.8903 89 5 135 Low 50 1 23 101 192 125.4 52 4 4.2905 80 7 97 Low 23 1 22.6 89 139 64.8 61 2 4.1897 68 1 19-29 2 30-39 3 40-49 4 50-59 5 60-69 6 70+ B 138 Low 36 2 22 90 160 99.6 50 3 3.9512 82 9 63 Low 66 2 26.2 114 255 185 56 4.55 4.2485 92 0123 110 Low 60 2 32.1 83 179 119.4 42 4 4.4773 94 310 High 29 1 30 85 180 93.4 43 4 5.3845 88 2 101 Low 22 1 18.6 97 114 57.6 46 2 3.9512 83 69 Low 56 2 28 85 184 144.8 32 6 3.5835 77 st 4 179 Low 53 1 23.7 92 186 109.2 62 62 3 4.3041 81 UT 185 Low 50 2 26.2 97 186 105.4 49 4 5.0626 88 6 7 118 Low 61 1 24 91 202 115.4 72 3 4.2905 73 171 Low 34 2 24.7 118 254 184.2 39 7 5.037 81 8 166 Low 47 1 30.3 109 207 100.2 70 3 5.2149 98 901 144 Low 68 2 27.5 111 214 147 39 5 4.9416 91 97 Low 38 1 25.4 84 162 103 42 4 4.4427 87 168 Low Data 41 1 24.7 83 187 108.2 60 3 4.5433 78 + R S