Spreadsheet: 747923d1631783668-xlookup-checking-2-lots-of-data-vertical-and-horizontal-1
Sheet: Sheet1

 |  |  |  | WK 19 | WK 20 | WK 21 | WK 22 | WK 23 | WK 24 | WK 25 | WK 26 | WK 27 | WK 28 | WK 29 | WK 30 | WK 31 | WK 32 | WK 33 | WK 34 | WK 35 | WK 36 | WK 37
 | 18 | Reason
 |  | Inclusions |  | 845 | 37 | 184 | 0 | 33 | 14 | 567 | 1020 | 476 | 2 | 2198 | 20 | 0 | 98 | 0 | 35 | 0 | 44 | 0 |  |  | 845 | 37 | 184 | 0 | 33 | 14 | 567 | 1020 | 476 | 2 | 2198 | 20 | 0 | 98 | 0 | 35 | 0 | 44 | 0
 |  | Runs | 25 | 515 | 22 | 576 | 0 | 179 | 156 | 1548 | 1205 | 575 | 10 | 6 | 1 | 0 | 97 | 0 | 27 | 0 | 36 | 0 |  |  | 515 | 22 | 576 | 0 | 179 | 156 | 1548 | 1205 | 575 | 10 | 6 | 1 | 0 | 97 | 0 | 27 | 0 | 36 | 0
 |  | Lack of paint | 18 | 245 | 9 | 66 | 0 | 20 | 99 | 1203 | 522 | 482 | 6 | 0 | 1 | 0 | 82 | 81 | 69 | 0 | 35 | 64 |  |  | 245 | 9 | 66 | 0 | 20 | 99 | 1203 | 522 | 482 | 6 | 0 | 1 | 0 | 82 | 81 | 69 | 0 | 35 | 64
 |  | Contamination | 0 | 172 | 56 | 193 | 0 | 16 | 25 | 119 | 1045 | 352 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 |  |  | 172 | 56 | 193 | 0 | 16 | 25 | 119 | 1045 | 352 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0
 |  | Scratches | 4 | 151 | 0 | 0 | 0 | 1 | 0 | 77 | 75 | 15 | 0 | 0 | 0 | 0 | 181 | 0 | 0 | 0 | 0 | 0 |  |  | 151 | 0 | 0 | 0 | 1 | 0 | 77 | 75 | 15 | 0 | 0 | 0 | 0 | 181 | 0 | 0 | 0 | 0 | 0
 |  | Flash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damage | 0 | 0 | 1 | 1 | 0 | 5 | 28 | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 1 | 1 | 0 | 5 | 28 | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Solvent Boil | 50 | 450 | 9 | 0 | 0 | 0 | 25 | 511 | 18 | 69 | 0 | 0 | 74 | 0 | 124 | 0 | 0 | 0 | 11 | 0 |  |  | 450 | 9 | 0 | 0 | 0 | 25 | 511 | 18 | 69 | 0 | 0 | 74 | 0 | 124 | 0 | 0 | 0 | 11 | 0
 |  | Patchy paint | 0 | 48 | 13 | 0 | 0 | 3 | 6 | 127 | 490 | 91 | 0 | 0 | 0 | 0 | 43 | 0 | 0 | 0 | 12 | 0 |  |  | 48 | 13 | 0 | 0 | 3 | 6 | 127 | 490 | 91 | 0 | 0 | 0 | 0 | 43 | 0 | 0 | 0 | 12 | 0
 |  | Water damage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sinks | 0 | 0 | 71 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 71 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Securing [NAME] | 28 | 76 | 0 | 37 | 0 | 0 | 0 | 245 | 205 | 64 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 20 | 0 |  |  | 76 | 0 | 37 | 0 | 0 | 0 | 245 | 205 | 64 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 20 | 0
 |  | Orange Peel | 74 | 288 | 3 | 20 | 0 | 0 | 32 | 434 | 14 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 17 | 0 |  |  | 288 | 3 | 20 | 0 | 0 | 32 | 434 | 14 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 17 | 0
 |  | Plastics Fault | 253 | 866 | 41 | 1 | 0 | 90 | 593 | 294 | 1257 | 329 | 0 | 4 | 0 | 0 | 41 | 24 | 0 | 0 | 5 | 0 |  |  | 866 | 41 | 1 | 0 | 90 | 593 | 294 | 1257 | 329 | 0 | 4 | 0 | 0 | 41 | 24 | 0 | 0 | 5 | 0
 |  | Post Paint Damage | 0 | 2 | 0 | 0 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  | 2 | 0 | 0 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | Sanding Marks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Polish Marks | 226 | 95 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 |  |  | 95 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0
 |  | First, Middle, Last off | 0 | 24 | 8 | 3 | 0 | 0 | 12 | 14 | 36 | 8 | 0 | 8 | 0 | 0 | 0 | 0 | 2 | 0 | 3 | 0 |  |  | 24 | 8 | 3 | 0 | 0 | 12 | 14 | 36 | 8 | 0 | 8 | 0 | 0 | 0 | 0 | 2 | 0 | 3 | 0
 |  | Robot Fault | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 96 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 96 | 0 | 0 | 0
 |  | Colour Issue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Reason | WK 1 | WK 2 | WK 3 | WK 4 | WK 5 | WK 6 | WK 7 | WK 8 | WK 9 | WK 10 | WK 11 | WK 12 | WK 13 | WK 14 | WK 15 | WK 16 | WK 17 | WK 18 | WK 19 | WK 20 | WK 21 | WK 22 | WK 23 | WK 24 | WK 25 | WK 26 | WK 27 | WK 28 | WK 29 | WK 30 | WK 31 | WK 32 | WK 33 | WK 34 | WK 35 | WK 36 | WK 37 | WK 38 | WK 39 | WK 40 | WK 41 | WK 42 | WK 43 | WK 44 | WK 45 | WK 46 | WK 47 | WK 48 | WK 49 | WK 50 | WK 51 | WK 52
 |  | Inclusions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 206 | 845 | 37 | 184 | 0 | 33 | 14 | 567 | 1020 | 476 | 2 | 2198 | 20 | 0 | 98 | 0 | 35 | 0 | 44 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Runs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 515 | 22 | 576 | 0 | 179 | 156 | 1548 | 1205 | 575 | 10 | 6 | 1 | 0 | 97 | 0 | 27 | 0 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Lack of paint | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 245 | 9 | 66 | 0 | 20 | 99 | 1203 | 522 | 482 | 6 | 0 | 1 | 0 | 82 | 81 | 69 | 0 | 35 | 64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Contamination | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 172 | 56 | 193 | 0 | 16 | 25 | 119 | 1045 | 352 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Scratches | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 151 | 0 | 0 | 0 | 1 | 0 | 77 | 75 | 15 | 0 | 0 | 0 | 0 | 181 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Flash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Damage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 5 | 28 | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Solvent Boil | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 450 | 9 | 0 | 0 | 0 | 25 | 511 | 18 | 69 | 0 | 0 | 74 | 0 | 124 | 0 | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Patchy paint | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 13 | 0 | 0 | 3 | 6 | 127 | 490 | 91 | 0 | 0 | 0 | 0 | 43 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Water damage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sinks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 71 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Securing [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28 | 76 | 0 | 37 | 0 | 0 | 0 | 245 | 205 | 64 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Orange Peel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 74 | 288 | 3 | 20 | 0 | 0 | 32 | 434 | 14 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Plastics Fault | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 253 | 866 | 41 | 1 | 0 | 90 | 593 | 294 | 1257 | 329 | 0 | 4 | 0 | 0 | 41 | 24 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Post Paint Damage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sanding Marks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Polish Marks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 226 | 95 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | First, Middle, Last off | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 8 | 3 | 0 | 0 | 12 | 14 | 36 | 8 | 0 | 8 | 0 | 0 | 0 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Robot Fault | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 96 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Colour Issue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 884 | 3777 | 270 | 1085 | 0 | 374 | 990 | 5157 | 5887 | 2461 | 27 | 2243 | 96 | 0 | 720 | 105 | 229 | 0 | 200 | 64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0