Spreadsheet: 845078d1696621673-problem-with-vlookup-test-1-
Sheet: DATA CAPTURE

 |  | Linked | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  | WEEKLY DATA CAPTURE COMPLIANCE
 |  |  | ENTER STORE NUMBER | 352 |  |  | WEEK ENDING:
 |  | STORE | STORE NAME | CASHIER ID | TRANS COUNT | [NAME] | [NAME] % WTD | [NAME] MTD | [NAME] % QTD | [NAME] YTD
 |  |  | [NAME] | -1 | 6 | 3 | 0.5 | 0.7 | 0.581395348837209 | 0.581395348837209
 |  | 352 | [NAME] | 206864 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 207510 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 219515 | 0 | 0 | 0 | 0 | 0.875 | 0.875
 |  | 352 | [NAME] | 221805 | 21 | 21 | 1 | 1 | 0.926470588235294 | 0.926470588235294
 |  | 352 | [NAME] | 222608 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 230146 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 235624 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 237615 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 240673 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 245536 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 245577 | 10 | 10 | 1 | 0.970149253731343 | 0.954887218045113 | 0.954887218045113
 |  | 352 | [NAME] | 246872 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 248020 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 249025 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 251329 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 255914 | 169 | 162 | 0.958579881656805 | 0.947368421052632 | 0.932865731462926 | 0.932865731462926
 |  | 352 | [NAME] | 263112 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 263183 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 263353 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 263969 | 262 | 244 | 0.931297709923664 | 0.938775510204082 | 0.943983402489627 | 0.943983402489627
 |  | 352 | [NAME] | 263975 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 264239 | 11 | 10 | 0.909090909090909 | 0.961538461538462 | 0.955882352941177 | 0.955882352941177
 |  | 352 | [NAME] | 264938 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 265032 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 352689 | 52 | 47 | 0.903846153846154 | 0.903614457831325 | 0.918518518518519 | 0.918518518518519
 |  | 352 | [NAME] | 353585 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 353699 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 354335 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 354339 | 59 | 55 | 0.932203389830508 | 0.936936936936937 | 0.950892857142857 | 0.950892857142857
 |  | 352 | [NAME] | 354409 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 354830 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 355603 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 356025 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 356194 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 356288 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 356303 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 356679 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 359099 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 359123 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 359249 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 360120 | 41 | 36 | 0.878048780487805 | 0.917808219178082 | 0.912280701754386 | 0.912280701754386
 |  | 352 | [NAME] | 361168 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 361731 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 361898 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 363280 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 363585 | 0 | 0 | 0 | 0 | 0.945205479452055 | 0.945205479452055
 |  | 352 | [NAME] | 363729 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 352 | [NAME] | 363938 | 0 | 0 | 0 | 0 | 0.940860215053764 | 0.940860215053764
 |  | 352 | [NAME] | 366093 | 0 | 0 | 0 | 0 | 0.984848484848485 | 0.984848484848485
 |  | 352 | [NAME] | 367668 | 230 | 216 | 0.939130434782609 | 0.95 | 0.948896631823461 | 0.948896631823461
 |  | 352 | [NAME] | 367772 | 68 | 64 | 0.941176470588235 | 0.953125 | 0.91219512195122 | 0.91219512195122
 |  | 352 | [NAME] | 369549 | 0 | 0 | 0 | 0 | 1 | 1
 |  | 352 | [NAME] | 370235 | 0 | 0 | 0 | 1 | 1 | 1
 |  | 352 | [NAME] | 370728 | 17 | 17 | 1 | 0.955555555555556 | 0.96039603960396 | 0.96039603960396
 |  | 352 | [NAME] | 371048 | 0 | 0 | 0 | 0.916666666666667 | 0.941666666666667 | 0.941666666666667
 |  | 352 | [NAME] | 372622 | 241 | 217 | 0.900414937759336 | 0.895043731778426 | 0.865156418554477 | 0.865156418554477
 |  | 352 | [NAME] | 372679 | 2 | 2 | 1 | 0.823529411764706 | 0.871794871794872 | 0.871794871794872
 |  | 352 | [NAME] | 373745 | 0 | 0 | 0 | 0 | 0.857142857142857 | 0.857142857142857
 |  | 352 | [NAME] | 373951 | 22 | 22 | 1 | 1 | 1 | 1
 |  | 352 | [NAME] | 374014 | 360 | 336 | 0.933333333333333 | 0.941176470588235 | 0.958019375672766 | 0.958019375672766
 |  | 352 | [NAME] | 374022 | 0 | 0 | 0 | 0.916666666666667 | 0.876190476190476 | 0.876190476190476
 |  | 352 | [NAME] | 374181 | 27 | 24 | 0.888888888888889 | 0.909090909090909 | 0.958762886597938 | 0.958762886597938
 |  | 352 | [NAME] | 374439 | 448 | 398 | 0.888392857142857 | 0.900398406374502 | 0.930835734870317 | 0.930835734870317
 |  | 352 | [NAME] | 375033 | 31 | 22 | 0.709677419354839 | 0.755102040816327 | 0.766393442622951 | 0.766393442622951
 |  | 352 | [NAME] | 375359 | 4 | 2 | 0.5 | 0.75 | 0.896825396825397 | 0.896825396825397
 |  | 352 | [NAME] | 376728 | 0 | 0 | 0 | 0 | 0.785714285714286 | 0.785714285714286
 |  | 352 | [NAME] | 376886 | 102 | 60 | 0.588235294117647 | 0.570342205323194 | 0.638190954773869 | 0.638190954773869
 |  | 352 | [NAME] | 376984 | 40 | 32 | 0.8 | 0.842105263157895 | 0.842105263157895 | 0.842105263157895
 |  | 352 | [NAME] | 377157 | 23 | 14 | 0.608695652173913 | 0.706896551724138 | 0.706896551724138 | 0.706896551724138
 |  | 352 | [NAME] | 377181 | 22 | 20 | 0.909090909090909 | 0.962264150943396 | 0.962264150943396 | 0.962264150943396
 |  | 352 | [NAME] | 377591 | 0 | 0 | 0 | 0.9375 | 0.9375 | 0.9375
 |  | 352 | [NAME] | 377630 | 94 | 92 | 0.978723404255319 | 0.970260223048327 | 0.917948717948718 | 0.917948717948718
 |  | 352 | [NAME] | 377712 | 23 | 20 | 0.869565217391304 | 0.869565217391304 | 0.869565217391304 | 0.869565217391304
 |  | 352 | [NAME] | 377964 | 9 | 9 | 1 | 1 | 1 | 1