Spreadsheet: 199637d1355267570-index-match-and-or-sumproduct-solution-example
Sheet: Data (1) 

Subject # | Study | Sex | Collection Interval
201 | 101 | M | 11 | Terminal | 4.3 | 11.16 | 16.3 | 56.4 | 50.5 | 14.6 | 28.9 | 1246 | 333 | 0.42 | 3.62 | 0.06 | 0.12 | 0.01 | 0.05
202 | 101 | M | 11 | Terminal | 6.7 | 11.16 | 16.2 | 57.5 | 51.5 | 14.5 | 28.1 | 1367 | 357.6 | 0.56 | 5.7 | 0.07 | 0.2 | 0.04 | 0.11
203 | 101 | M | 11 | Terminal | 6.4 | 10.98 | 16.2 | 55.9 | 50.9 | 14.7 | 28.9 | 1337 | 313.4 | 0.7 | 5.32 | 0.04 | 0.14 | 0.04 | 0.15
204 | 101 | M | 11 | Terminal | 7.4 | 10.86 | 16 | 55.5 | 51.1 | 14.8 | 28.9 | 1137 | 313.1 | 0.71 | 5.93 | 0.07 | 0.46 | 0.07 | 0.2
205 | 101 | M | 11 | Terminal | 4.3 | 10.24 | 15 | 52.5 | 51.2 | 14.6 | 28.6 | 1396 | 292.3 | 1.25 | 2.86 | 0.03 | 0.09 | 0.06 | 0.06
206 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | C | C
207 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | C | C
208 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27.6 | 11.1 | 223
209 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | C | C
210 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.9 | 11.2 | 226
286 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27.4 | 10.8 | 176
287 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28.4 | 11.6 | 168
288 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29.9 | 11.7 | 160
289 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 11.1 | 198
290 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.1 | 11 | 181
211 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 156 | 8.2 | 110 | 33 | 9.9 | 9.8 | 94 | 0.2 | 324 | 56 | 1385 | 26 | 0.2 | 5.6 | 2.9 | 2.7 | 1.1 | 97 | 92 | 196
212 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 153 | 9 | 109 | 32 | 10.2 | 9.7 | 106 | 0.1 | 78 | 28 | 198 | 31 | 0.2 | 5.7 | 3.3 | 2.4 | 1.4 | 79 | 98 | 212
213 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 152 | 9.4 | 112 | 32 | 9.9 | 10.7 | 101 | 0.2 | 90 | 37 | 255 | 25 | 0.2 | 5.3 | 2.9 | 2.4 | 1.2 | 71 | 82 | 219
214 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 153 | 8.7 | 110 | 28 | 10.4 | 10.4 | 93 | 0.1 | 59 | 38 | 117 | 22 | 0.2 | 5.2 | 3 | 2.2 | 1.4 | 103 | 87 | 250
215 | 101 | M | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 156 | 8.3 | 111 | 31 | 10.8 | 10.6 | 92 | 0.2 | 90 | 39 | 231 | 27 | 0.2 | 5.6 | 3.3 | 2.3 | 1.4 | 117 | 93 | 241
291 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 9.1 | 108 | 37 | 10.2 | 10.6 | 146 | 0.2 | 66 | 30 | 142 | 17 | 0.2 | 5.2 | 3.2 | 2 | 1.6 | 63 | 82 | 219
292 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 152 | 9.7 | 109 | 38 | 10.2 | 10.7 | 152 | 0.2 | 85 | 28 | 185 | 20 | 0.2 | 5.2 | 3.3 | 1.9 | 1.7 | 68 | 71 | 263
293 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 157 | 8.5 | 111 | 37 | 11.1 | 10.5 | 158 | 0.2 | 95 | 36 | 208 | 28 | 0.3 | 5.7 | 3.5 | 2.2 | 1.6 | 71 | 86 | 298
294 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149 | 8.6 | 107 | 39 | 9.8 | 10.5 | 116 | 0.2 | 63 | 29 | 117 | 18 | 0.2 | 4.8 | 2.9 | 1.9 | 1.5 | 80 | 81 | 246
295 | 101 | F | 11 | Terminal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 152 | 7.7 | 110 | 37 | 9.6 | 10 | 124 | 0.2 | 222 | 33 | 823 | 17 | 0.2 | 5 | 3 | 2 | 1.5 | 64 | 78 | 234
216 | 101 | M | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 151 | 10 | 109 | 27 | 11.1 | 10.7 | 87 | 0.1 | 157 | 138 | 299 | 25 | 0.2 | 5.6 | 3.1 | 2.5 | 1.2 | 112 | 94 | 246
217 | 101 | M | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 152 | 8.5 | 109 | 30 | 10.1 | 10.3 | 99 | 0.1 | 59 | 39 | 128 | 23 | 0.2 | 5.4 | 3 | 2.4 | 1.3 | 98 | 83 | 240
218 | 101 | M | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 147 | 7.9 | 108 | 29 | 10.3 | 9.6 | 103 | 0.2 | 101 | 37 | 414 | 24 | 0.2 | 5.2 | 3 | 2.2 | 1.4 | 108 | 86 | 252
219 | 101 | M | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 8.2 | 109 | 29 | 10.2 | 10.8 | 89 | 0.2 | 178 | 41 | 754 | 29 | 0.2 | 5 | 2.8 | 2.2 | 1.3 | 100 | 88 | 231
220 | 101 | M | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149 | 8.7 | 110 | 29 | 10.2 | 11.7 | 94 | 0.2 | 117 | 42 | 475 | 27 | 0.2 | 4.8 | 2.7 | 2.1 | 1.3 | 103 | 93 | 255
296 | 101 | F | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149 | 7.6 | 109 | 28 | 10.6 | 9.9 | 104 | 0.2 | 130 | 39 | 386 | 20 | 0.2 | 5.4 | 3.2 | 2.2 | 1.5 | 98 | 94 | 261
297 | 101 | F | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 148 | 8 | 107 | 29 | 10.8 | 11 | 125 | 0.2 | 75 | 32 | 214 | 22 | 0.2 | 5.3 | 3.2 | 2.1 | 1.5 | 97 | 93 | 292
298 | 101 | F | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QNS | QNS | QNS | 25 | 9.8 | QNS | 122 | 0.1 | 141 | 40 | QNS | 23 | 0.2 | 5.1 | 3 | 2.1 | 1.4 | 85 | 84 | 215
299 | 101 | F | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 8.2 | 110 | 31 | 10.6 | 10.4 | 130 | 0.1 | 60 | 31 | 98 | 28 | 0.2 | 5.5 | 3.5 | 2 | 1.8 | 55 | 85 | 268
300 | 2078-001 | F | 13 | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149 | 7.9 | 109 | 32 | 10.1 | 10 | 111 | 0.1 | 79 | 27 | 216 | 18 | 0.2 | 5.2 | 3 | 2.2 | 1.4 | 73 | 85 | 232