Spreadsheet: 63546d1264445895-vlookup-with-multiple-returns-user-test-run
Sheet: Summary

User ID | User Name | Total Rejected # | Total Rejected $ | # of Demographic Errors | # of Charge Errors | Facility
16 | User1 | 2 | 942.51 | 2 | 0 | Facility1
35 | User2 | 4 | 1237.66 | 9 | 0 | Facility1
40 | User3 | 3 | 2065.64 | 4 | 0 | Facility1
43 | User4 | 1 | 336.37 | 1 | 0 | Facility1
53 | [NAME] | 2 | 0 | 4 | 0 | Facility1
55 | [NAME] | 1 | 451.52 | 2 | 0 | Facility1
67 | User7 | 2 | 343.91 | 4 | 0 | Facility1
73 | User8 | 1 | 677.28 | 3 | 0 | Facility1
78 | [NAME] | 4 | 927.44 | 10 | 0 | Facility1
87 | User10 | 1 | 400.31 | 1 | 0 | Facility1
92 | User11 | 1 | 624.96 | 1 | 1 | Facility1
106 | User12 | 2 | 637.55 | 2 | 0 | Facility1
111 | User13 | 1 | 6640.44 | 1 | 0 | Facility1
112 | User14 | 4 | 433.88 | 8 | 0 | Facility1
117 | User15 | 1 | 1114.08 | 0 | 1 | Facility1
121 | User16 | 31 | 8056.07 | 33 | 31 | Facility1
122 | User17 | 1 | 336.37 | 1 | 0 | Facility1
126 | User18 | 2 | 284.76 | 4 | 0 | Facility1
127 | User19 | 2 | 205.2 | 4 | 0 | Facility1
131 | User20 | 2 | 336.37 | 4 | 0 | Facility1
157 | User21 | 1 | 91.61 | 3 | 0 | Facility1
167 | User22 | 3 | 1548.8 | 4 | 0 | Facility1
190 | User23 | 2 | 156.9 | 4 | 0 | Facility1
227 | User24 | 1 | 339.76 | 2 | 0 | Facility1
233 | User25 | 1 | 1263.24 | 2 | 0 | Facility1
235 | User26 | 4 | 1021.23 | 4 | 0 | Facility1
248 | User27 | 1 | 43008.72 | 4 | 0 | Facility1
263 | User28 | 3 | 786.12 | 10 | 0 | Facility1
270 | User29 | 5 | 3174.06 | 5 | 0 | Facility1
279 | User30 | 1 | 144.46 | 4 | 0 | Facility1
296 | User31 | 2 | 343.91 | 2 | 0 | Facility1
297 | User32 | 1 | 238.17 | 1 | 0 | Facility1
311 | User33 | 3 | 979.21 | 5 | 0 | Facility1
313 | User34 | 2 | 0 | 4 | 0 | Facility1
336 | User35 | 6 | 1634.73 | 10 | 0 | Facility1
350 | User36 | 1 | 0 | 2 | 0 | Facility1
368 | User37 | 1 | 945 | 1 | 0 | Facility1
373 | User38 | 1 | 156.9 | 1 | 0 | Facility1
384 | User39 | 1 | 0 | 1 | 0 | Facility1
419 | User40 | 3 | 188.5 | 4 | 0 | Facility1
537 | [NAME] | 1 | 952.24 | 3 | 0 | Facility1
540 | User42 | 1 | 0 | 2 | 0 | Facility1
553 | User43 | 1 | 0 | 1 | 0 | Facility1
643 | User44 | 8 | 3888.72 | 8 | 8 | Facility1
650 | User45 | 1 | 0 | 2 | 0 | Facility1
656 | User46 | 7 | 431.65 | 12 | 1 | Facility1
657 | User47 | 1 | 206.56 | 1 | 0 | Facility1
667 | User48 | 1 | 0 | 1 | 0 | Facility1
677 | User49 | 3 | 3710.31 | 3 | 0 | Facility1
680 | User50 | 1 | 395.08 | 1 | 1 | Facility1
748 | [NAME] | 1 | 0 | 2 | 0 | Facility1
753 | User52 | 3 | 1409.93 | 5 | 0 | Facility1
757 | [NAME] | 1 | 156.9 | 1 | 0 | Facility1
758 | User54 | 1 | 123.03 | 1 | 0 | Facility1
760 | User55 | 1 | 131.08 | 0 | 2 | Facility1
784 | User56 | 7 | 2541.15 | 11 | 0 | Facility1
789 | User57 | 1 | 1444.8 | 3 | 0 | Facility1
816 | User58 | 1 | 84.66 | 1 | 0 | Facility1
834 | User59 | 1 | 0 | 2 | 0 | Facility1
855 | User60 | 12 | 6640.92 | 12 | 0 | Facility1
861 | User61 | 5 | 2669.62 | 7 | 0 | Facility1
883 | User62 | 2 | 356.78 | 4 | 0 | Facility1
886 | User63 | 1 | 6714 | 1 | 0 | Facility1
889 | User64 | 1 | 1102.5 | 0 | 1 | Facility1
920 | User65 | 9 | 1636.07 | 22 | 0 | Facility1
932 | User66 | 3 | 281.78 | 3 | 0 | Facility1
945 | [NAME] | 2 | 468.74 | 2 | 0 | Facility1
957 | User68 | 41 | 20045.03 | 48 | 39 | Facility1
966 | User69 | 1 | 270.78 | 1 | 0 | Facility1
973 | User70 | 7 | 2015.95 | 14 | 0 | Facility1
980 | User71 | 1 | 1128.8 | 1 | 0 | Facility1
985 | User72 | 1 | 156.9 | 2 | 0 | Facility1
986 | User73 | 2 | 713.51 | 4 | 0 | Facility1
996 | User74 | 1 | 0 | 2 | 0 | Facility1
1006 | [NAME] | 1 | 0 | 4 | 0 | Facility1
1039 | User76 | 1 | 282.2 | 1 | 0 | Facility1
1047 | User77 | 1 | 0 | 1 | 0 | Facility1
1051 | User78 | 2 | 165.45 | 4 | 0 | Facility1
1055 | User79 | 1 | 650.76 | 1 | 0 | Facility1
1057 | User80 | 2 | 559.86 | 2 | 0 | Facility1
1063 | User81 | 3 | 3702.74 | 3 | 0 | Facility1
1260 | User82 | 7 | 1250.29 | 14 | 0 | Facility1
1270 | User83 | 1 | 6926.01 | 1 | 1 | Facility1
1500 | User84 | 1 | 790.16 | 1 | 0 | Facility1
1780 | User85 | 1 | 1680 | 1 | 0 | Facility1
2010 | User86 | 2 | 1016.12 | 2 | 0 | Facility1
2030 | User87 | 5 | 2084.87 | 9 | 0 | Facility1
2316 | User88 | 1 | 255.1 | 0 | 1 | Facility1
2317 | User89 | 1 | 2085.93 | 2 | 0 | Facility1
2321 | User90 | 2 | 156.9 | 3 | 0 | Facility1
2332 | User91 | 1 | 380.66 | 1 | 0 | Facility1
2342 | User92 | 1 | 42.6 | 3 | 0 | Facility1
2347 | User93 | 1 | 0 | 2 | 0 | Facility1
2378 | User94 | 1 | 1298.12 | 4 | 0 | Facility1
2380 | User95 | 5 | 905.55 | 10 | 0 | Facility1
2383 | User96 | 172 | 110311.05 | 175 | 428 | Facility1
2417 | User97 | 6 | 3451.96 | 8 | 0 | Facility1
2430 | User98 | 1 | 29.92 | 3 | 0 | Facility1
2441 | User99 | 1 | 31.6 | 3 | 0 | Facility1
2465 | User100 | 3 | 879.57 | 5 | 0 | Facility1
2484 | User101 | 1 | 846.6 | 3 | 0 | Facility1
2486 | User102 | 3 | 1323.5 | 4 | 0 | Facility1
2487 | User103 | 1 | 229.8 | 1 | 0 | Facility1
2488 | User104 | 8 | 6174.47 | 8 | 0 | Facility1
2529 | User105 | 1 | 384.91 | 1 | 0 | Facility1
2609 | User106 | 1 | 0 | 2 | 0 | Facility1
2611 | User107 | 6 | 3450.88 | 12 | 0 | Facility1
2634 | User108 | 12 | 3273.42 | 12 | 0 | Facility1
2639 | User109 | 1 | 187.01 | 3 | 0 | Facility1
2640 | User110 | 6 | 1042.09 | 6 | 0 | Facility1
2646 | User111 | 7 | 9523.96 | 7 | 15 | Facility1
2686 | User112 | 1 | 226.88 | 1 | 0 | Facility1
2690 | User113 | 8 | 2913.99 | 19 | 0 | Facility1
2693 | User114 | 1 | 650.76 | 1 | 0 | Facility1
2707 | User115 | 1 | 199.88 | 3 | 0 | Facility1
2709 | User116 | 3 | 559.86 | 4 | 0 | Facility1
2741 | User117 | 1 | 649.29 | 1 | 0 | Facility1
2755 | User118 | 4 | 593.73 | 4 | 0 | Facility1
2770 | User119 | 18 | 15521 | 18 | 28 | Facility1
2778 | User120 | 3 | 2105.82 | 5 | 0 | Facility1
2793 | User121 | 4 | 1381.97 | 8 | 5 | Facility1
2826 | User122 | 7 | 1376.57 | 9 | 0 | Facility1
2828 | User123 | 6 | 3558.92 | 6 | 6 | Facility1
2829 | User124 | 54 | 47354.7 | 55 | 54 | Facility1
2831 | User125 | 16 | 8024.34 | 16 | 31 | Facility1
2832 | User126 | 5 | 24441.6 | 5 | 5 | Facility1
2833 | User127 | 1 | 415 | 1 | 0 | Facility1
2842 | User128 | 33 | 40447.42 | 34 | 42 | Facility1
2880 | User129 | 280 | 117544.92 | 295 | 277 | Facility1
2905 | User130 | 1 | 340.88 | 1 | 0 | Facility1
2907 | User131 | 111 | 80524.74 | 116 | 110 | Facility1
2908 | User132 | 2 | 680.63 | 2 | 0 | Facility1
2913 | User133 | 4 | 457.92 | 4 | 0 | Facility1
2924 | User134 | 2 | 1599.44 | 2 | 0 | Facility1
2933 | User135 | 42 | 0 | 44 | 0 | Facility1
2937 | User136 | 29 | 42423.03 | 29 | 32 | Facility1
2948 | User137 | 1 | 1354.52 | 1 | 5 | Facility1
2954 | [NAME] | 72 | 109687.85 | 76 | 86 | Facility1
2957 | User139 | 14 | 20237.68 | 14 | 19 | Facility1
2962 | User140 | 416 | 132460.47 | 429 | 562 | Facility1
2963 | User141 | 42 | 16701.6 | 42 | 43 | Facility1
2989 | User142 | 5 | 1923.44 | 5 | 0 | Facility1
2993 | User143 | 180 | 56646.63 | 187 | 182 | Facility1
2996 | User144 | 80 | 13084.4 | 82 | 92 | Facility1
3001 | User145 | 112 | 20435.61 | 113 | 144 | Facility1
3004 | [NAME] | 208 | 107661.73 | 219 | 225 | Facility1
3013 | [NAME] | 24 | 196362.83 | 26 | 48 | Facility1
3020 | User148 | 4 | 28278.61 | 4 | 0 | Facility1
3028 | User149 | 89 | 34700.81 | 92 | 156 | Facility1
3034 | User150 | 4 | 786.02 | 4 | 4 | Facility1
3040 | User151 | 1 | 3054.84 | 1 | 1 | Facility1
3062 | User152 | 28 | 14704.47 | 36 | 46 | Facility1
3076 | User153 | 24 | 7205.88 | 25 | 34 | Facility1
3360 | User154 | 3 | 594.92 | 4 | 0 | Facility1
7702 | User155 | 5 | 0 | 7 | 0 | Facility1
7704 | User156 | 4 | 371.95 | 6 | 0 | Facility1
7705 | User157 | 1 | 0 | 1 | 0 | Facility1
7706 | User158 | 15 | 177.58 | 15 | 0 | Facility1
7714 | User159 | 2 | 0 | 2 | 0 | Facility1
7716 | User160 | 6 | 73.5 | 8 | 0 | Facility1
7727 | User161 | 2 | 374.02 | 2 | 0 | Facility1
7770 | User162 | 9 | 0 | 12 | 0 | Facility1
8812 | User163 | 2 | 0 | 2 | 0 | Facility1
8838 | User164 | 3 | 0 | 3 | 0 | Facility1
8842 | User165 | 1 | 0 | 1 | 0 | Facility1
8844 | User166 | 1 | 0 | 1 | 0 | Facility1
8890 | User167 | 1 | 0 | 1 | 0 | Facility1
9117 | User168 | 7 | 7018.87 | 7 | 0 | Facility1
9118 | User169 | 7 | 2687.18 | 7 | 0 | Facility1
9180 | User170 | 2 | 553.85 | 6 | 0 | Facility1
9186 | User171 | 6 | 1491.16 | 9 | 6 | Facility1
9189 | User172 | 3 | 13408.56 | 3 | 5 | Facility1
9190 | User173 | 1 | 336.37 | 1 | 0 | Facility1
9198 | User174 | 2 | 553.85 | 6 | 0 | Facility1
9210 | User175 | 1 | 0 | 2 | 0 | Facility1
9241 | User176 | 2 | 412.76 | 2 | 0 | Facility1
9245 | User177 | 4 | 278.8 | 6 | 0 | Facility1
9249 | User178 | 1 | 0 | 2 | 0 | Facility1
9263 | User179 | 4 | 805.05 | 4 | 0 | Facility1
A0024 | User180 | 1 | 121.91 | 1 | 0 | Facility1
A0104 | User181 | 2 | 218.94 | 5 | 0 | Facility1
A0172 | User182 | 2 | 839.44 | 6 | 0 | Facility1
A0173 | User183 | 2 | 93.77 | 4 | 0 | Facility1
A0254 | User184 | 2 | 104.18 | 6 | 0 | Facility1
A0397 | User185 | 2 | 48.75 | 4 | 0 | Facility1
A0441 | User186 | 3 | 750.62 | 3 | 2 | Facility1
A0468 | User187 | 1 | 156.9 | 1 | 0 | Facility1
A0733 | User188 | 1 | 0 | 2 | 0 | Facility1
A0842 | User189 | 2 | 74.24 | 3 | 2 | Facility1
A1051 | User190 | 2 | 339.76 | 2 | 0 | Facility1
A2347 | User191 | 1 | 223.49 | 3 | 0 | Facility1
A2464 | User192 | 1 | 0 | 2 | 0 | Facility1
A2842 | User193 | 7 | 1814.24 | 7 | 14 | Facility1
A5181 | User194 | 1 | 0 | 1 | 0 | Facility1
A9241 | User195 | 1 | 45.85 | 4 | 0 | Facility1
A9266 | User196 | 1 | 121.91 | 1 | 0 | Facility1
B2842 | User197 | 59 | 36090.66 | 63 | 105 | Facility1
B3022 | User198 | 1 | 0 | 1 | 0 | Facility1
D2609 | User199 | 1 | 156.9 | 1 | 0 | Facility1
[NAME] | User200 | 3 | 861.79 | 4 | 0 | Facility1
F0787 | User201 | 1 | 123.03 | 1 | 0 | Facility1
F0866 | User202 | 35 | 0 | 36 | 0 | Facility1
F2464 | User203 | 2 | 554.54 | 2 | 0 | Facility1
F2936 | User204 | 21 | 0 | 23 | 0 | Facility1
F3001 | User205 | 86 | 19001.48 | 88 | 120 | Facility1
F3009 | User206 | 171 | 23196.91 | 181 | 155 | Facility1
F7731 | User207 | 4 | 318.41 | 4 | 0 | Facility1
G0663 | User208 | 2 | 284.4 | 4 | 0 | Facility1
G0718 | User209 | 1 | 156.9 | 1 | 0 | Facility1
G0957 | User210 | 10 | 786.74 | 10 | 5 | Facility1
G0985 | User211 | 1 | 324.21 | 4 | 0 | Facility1
G1130 | User212 | 1 | 156.9 | 1 | 0 | Facility1
G2842 | User213 | 67 | 14260.79 | 73 | 99 | Facility1
G5242 | User214 | 2 | 1600.97 | 2 | 0 | Facility1
G7032 | User215 | 1 | 199.88 | 1 | 0 | Facility1
G7732 | User216 | 1 | 48.3 | 2 | 0 | Facility1
G7770 | User217 | 9 | 110.25 | 9 | 0 | Facility1
H0757 | User218 | 2 | 343.91 | 2 | 0 | Facility1
H2996 | User219 | 138 | 26376.5 | 143 | 168 | Facility1
H3009 | User220 | 4 | 687.82 | 4 | 4 | Facility1
H3059 | User221 | 38 | 806.4 | 41 | 10 | Facility1
H7733 | User222 | 5 | 73.5 | 5 | 0 | Facility1
I0661 | User223 | 1 | 156.9 | 1 | 0 | Facility1
I0957 | User224 | 4 | 313.8 | 4 | 2 | Facility1
I2842 | User225 | 1 | 156.9 | 1 | 1 | Facility1
I7734 | User226 | 2 | 0 | 2 | 0 | Facility1
J0185 | User227 | 2 | 279.93 | 2 | 0 | Facility1
J0313 | User228 | 1 | 464.6 | 1 | 0 | Facility1
[NAME] | User229 | 27 | 0 | 27 | 0 | Facility1
J0839 | User230 | 1 | 223.76 | 1 | 0 | Facility1
J0983 | User231 | 1 | 272.03 | 1 | 0 | Facility1
J2363 | User232 | 1 | 341.75 | 1 | 0 | Facility1
[NAME] | User233 | 54 | 0 | 56 | 0 | Facility1
J3023 | User234 | 1 | 0 | 1 | 0 | Facility1
J7735 | User235 | 18 | 220.5 | 18 | 0 | Facility1
J7770 | User236 | 7 | 726.14 | 7 | 0 | Facility1
K0924 | User237 | 1 | 464.6 | 1 | 0 | Facility1
K0957 | User238 | 4 | 349.91 | 4 | 2 | Facility1
K2347 | User239 | 1 | 156.9 | 3 | 0 | Facility1
K2685 | User240 | 2 | 392.21 | 6 | 0 | Facility1
K2686 | User241 | 3 | 652.8 | 3 | 0 | Facility1
K3023 | User242 | 55 | 0 | 58 | 0 | Facility1
[NAME] | User243 | 71 | 10492.35 | 82 | 66 | Facility1
226 | User244 | 1 | 280 | 0 | 1 | Facility4
432 | User245 | 4 | 1200 | 0 | 12 | Facility4
5132 | User246 | 2 | 5744 | 0 | 23 | Facility4
5364 | User247 | 8 | 2028 | 0 | 18 | Facility4
A0824 | User248 | 5 | 1424 | 0 | 13 | Facility4
A0828 | User249 | 9 | 2006 | 0 | 15 | Facility4
A2323 | User250 | 1 | 1276 | 0 | 1 | Facility4
B0375 | User251 | 3 | 860 | 0 | 6 | Facility4
B0833 | User252 | 5 | 1242 | 0 | 9 | Facility4
F5046 | User253 | 3 | 1356 | 0 | 9 | Facility4
5271 | User254 | 3 | 0 | 4 | 0 | Facility5
C5271 | User255 | 1 | 76 | 1 | 1 | Facility5
Q0426 | User256 | 1 | 0 | 1 | 0 | Facility5
A0322 | User257 | 7 | 2050 | 7 | 10 | Facility8
2311 | User258 | 1 | 0 | 1 | 0 | Facility6
[NAME] | User259 | 1 | 0 | 1 | 0 | Facility6
5094 | User260 | 3 | 0 | 3 | 0 | Facility7
5244 | User261 | 1 | 0 | 1 | 0 | Facility7
A0918 | User262 | 11 | 945.6 | 19 | 0 | Facility7
A2486 | User263 | 1 | 0 | 1 | 0 | Facility7
A2958 | User264 | 2 | 0 | 2 | 0 | Facility7
A9288 | User265 | 7 | 95.55 | 7 | 0 | Facility7
O0532 | User266 | 9 | 981.85 | 9 | 0 | Facility7
S0064 | User267 | 21 | 1461.46 | 28 | 0 | Facility7
S0209 | User268 | 3 | 11.11 | 6 | 0 | Facility7
S0286 | User269 | 17 | 341.95 | 22 | 0 | Facility7