Spreadsheet: 73517d1274186714-vlookup-format-test
Sheet: PROGRESS

 | DATA FROM CURRENT WPC REPORT
 |  | WPC PARTS | RECIEVED? | TOPIC |  | PART DESCRIPTIONS |  | Topic | Parts Required | Parts Missing | Parts Received | % Complete
 | 1 | 65461 | 65461 | P | 1 | 0 |  | P | 21 | 0 | 21 | 1
 | 2 | 45157 | 45157 | P | 1 | 0 |  | H | 7 | 7 | 0 | 0
 | 3 | 54790 | 54790 | P | 1 | 0 |  | PT | 27 | 0 | 27 | 1
 | 4 | 26520 | 26520 | P | 1 | 0 |  | 0 | 0
 | 5 | 90778 | 90778 | P | 1 | 0 |  | 0 | 0
 | 6 | 88582 | 88582 | P | 1 | 0 |  | 0 | 0
 | 7 | 21654 | 21654 | P | 1 | 0 |  | 0 | 0
 | 8 | 92508 | 92508 | P | 1 | 0 |  | 0 | 0
 | 9 | 76251 | 76251 | P | 1 | 0 |  | 0 | 0
 | 10 | 32926 | 32926 | P | 1 | 0 |  | 0 | 0
 | 11 | 56084 | 56084 | P | 1 | 0 |  | 0 | 0
 | 12 | 60057 | 60057 | P | 1 | 0 |  | 0 | 0
 | 13 | 75532 | 75532 | P | 1 | 0 |  | 0 | 0
 | 14 | 60922 | 60922 | P | 1 | 0 |  | 0 | 0
 | 15 | 35210 | 35210 | P | 1 | 0 |  | 0 | 0
 | 16 | 36132 | 36132 | P | 1 | 0 |  | 0 | 0
 | 17 | 98557 | 98557 | P | 1 | 0 |  | 0 | 0
 | 18 | 87566 | 87566 | P | 1 | 0 |  | 0 | 0
 | 19 | 66222 | 66222 | P | 1 | 0 |  | 0 | 0
 | 20 | 54813 | 54813 | P | 1 | 0 |  | 0 | 0
 | 21 | 69666 | 69666 | P | 1 | 0 |  | 0 | 0
 | 22 | 87411 | Missing | H | 1 | 0 |  | 0 | 0
 | 23 | 89969 | Missing | H | 1 | 0 |  | 0 | 0
 | 24 | 82813 | Missing | H | 1 | 0 |  | 0 | 0
 | 25 | 25245 | Missing | H | 1 | 0 |  | 0 | 0
 | 26 | 22258 | Missing | H | 1 | 0 |  | 0 | 0
 | 27 | 51193 | Missing | H | 1 | 0 |  | 0 | 0
 | 28 | 68845 | Missing | H | 1 | 0 |  | 0 | 0
 | 29 | 59115 | 59115 | PT | 1 | 0 |  | 0 | 0
 | 30 | 26624 | 26624 | PT | 1 | 0 |  | 0 | 0
 | 31 | 33798 | 33798 | PT | 1 | 0 |  | Totals | 55 | 7 | 48
 | 32 | 79091 | 79091 | PT | 1 | 0
 | 33 | 83479 | 83479 | PT | 1 | 0
 | 34 | 86322 | 86322 | PT | 1 | 0
 | 35 | 78470 | 78470 | PT | 1 | 0
 | 36 | 72516 | 72516 | PT | 1 | 0
 | 37 | 67824 | 67824 | PT | 1 | 0
 | 38 | 73009 | 73009 | PT | 1 | 0
 | 39 | 54371 | 54371 | PT | 1 | 0
 | 40 | 94344 | 94344 | PT | 1 | 0
 | 41 | 63187 | 63187 | PT | 1 | 0
 | 42 | 77721 | 77721 | PT | 1 | 0
 | 43 | 34941 | 34941 | PT | 1 | 0
 | 44 | 85687 | 85687 | PT | 1 | 0
 | 45 | 42931 | 42931 | PT | 1 | 0
 | 46 | 26102 | 26102 | PT | 1 | 0
 | 47 | 24835 | 24835 | PT | 1 | 0
 | 48 | 93720 | 93720 | PT | 1 | 0
 | 49 | 40955 | 40955 | PT | 1 | 0
 | 50 | 69343 | 69343 | PT | 1 | 0
 | 51 | 34431 | 34431 | PT | 1 | 0
 | 52 | 81112 | 81112 | PT | 1 | 0
 | 53 | 53439 | 53439 | PT | 1 | 0
 | 54 | 94019 | 94019 | PT | 1 | 0
 | 55 | 90922 | 90922 | PT | 1 | 0
 | 56 |  | Missing | 0 | 1 | 0
 | 57 |  | Missing | 0 | 1 | 0
 | 58 |  | Missing | 0 | 1 | 0
 | 59 |  | Missing | 0 | 1 | 0
 | 60 |  | Missing | 0 | 1 | 0
 | 61 |  | Missing | 0 | 1 | 0
 | 62 |  | Missing | 0 | 1 | 0
 | 63 |  | Missing | 0 | 1 | 0
 | 64 |  | Missing | 0 | 1 | 0
 | 65 |  | Missing | 0 | 1 | 0
 | 66 |  | Missing | 0 | 1 | 0
 | 67 |  | Missing | 0 | 1 | 0
 | 68 |  | Missing | 0 | 1 | 0
 | 69 |  | Missing | 0 | 1 | 0
 | 70 |  | Missing | 0 | 1 | 0
 | 71 |  | Missing | 0 | 1 | 0
 | 72 |  | Missing | 0 | 1 | 0
 | 73 |  | Missing | 0 | 1 | 0
 | 74 |  | Missing | 0 | 1 | 0
 | 75 |  | Missing | 0 | 1 | 0
 | 76 |  | Missing | 0 | 1 | 0
 | 77 |  | Missing | 0 | 1 | 0
 | 78 |  | Missing | 0 | 1 | 0
 | 79 |  | Missing | 0 | 1 | 0
 | 80 |  | Missing | 0 | 1 | 0
 | 81 |  | Missing | 0 | 1 | 0
 | 82 |  | Missing | 0 | 1 | 0
 | 83 |  | Missing | 0 | 1 | 0
 | 84 |  | Missing | 0 | 1 | 0
 | 85 |  | Missing | 0 | 1 | 0
 | 86 |  | Missing | 0 | 1 | 0
 | 87 |  | Missing | 0 | 1 | 0
 | 88 |  | Missing | 0 | 1 | 0
 | 89 |  | Missing | 0 | 1 | 0
 | 90 |  | Missing | 0 | 1 | 0
 | 91 |  | Missing | 0 | 1 | 0
 | 92 |  | Missing | 0 | 1 | 0
 | 93 |  | Missing | 0 | 1 | 0
 | 94 |  | Missing | 0 | 1 | 0
 | 95 |  | Missing | 0 | 1 | 0
 | 96 |  | Missing | 0 | 1 | 0
 | 97 |  | Missing | 0 | 1 | 0
 | 98 |  | Missing | 0 | 1 | 0
 | 99 |  | Missing | 0 | 1 | 0
 | 100 |  | Missing | 0 | 1 | 0