Spreadsheet: 65659d1266350850-excel-2007-match-on-multiple-criteria-infoforforums
Sheet: Data

R | District | Store | Invoice | Date | Acct | Account Name | Qty | Line | Item | Original Price | Override Price | [NAME] | Extended Original  Price | Extended Override Price | Extended Variance | [NAME]
19 | 113 | 1680 | 201125 | 20100102 | 1 | oad | 1 | CAS | 10-30 | 3.63 | N
5 | 144 | 601 | 278420 | 20100125 | 31 | oap | 12 | CAS | 10-30 | 3.63 | N
2 | 25 | 124 | 378633 | 20100120 | 10083 | [NAME] | 4 | CAS | 10-30 | 3.99 | 3.75 | -0.24 | 15.96 | 15 | -0.96 | -6
7 | 52 | 303 | 250679 | 20100127 | 10563 | ajh | 1 | CAS | 10-30 | 3.82 | N
1 | 20 | 75 | 402559 | 20100122 | 12226 | jg | 3 | CAS | 10-30 | 3.99 | 10.99 | 7 | 11.97 | 32.97 | 21 | 175.4
1 | 20 | 75 | 402564 | 20100122 | 12226 | jg | 3 | CAS | 10-30 | 10.99 | N
1 | 5 | 61 | 178372 | 20100127 | 12939 | fa | 1 | CAS | 10-30 | 3.99 | 10.99 | 7 | 3.99 | 10.99 | 7 | 175.4
1 | 4 | 73 | 183036 | 20100122 | 14438 | mssc | 6 | CAS | 10-30 | 3.99 | N
5 | 144 | 821 | 232425 | 20100127 | 18251 | sds | 6 | CAS | 10-30 | 3.99 | N
19 | 88 | 1108 | 396894 | 20100111 | 18466 | dadasdasd | 3 | CAS | 10-30 | 3.99 | 2.79 | -1.2 | 11.97 | 8.37 | -3.6 | -30.1
22 | 110 | 2188 | 119627 | 20100113 | 21721 | dadasdasd | 12 | CAS | 10-30 | 3.99 | 3.39 | -0.6 | 47.88 | 40.68 | -7.2 | -15
3 | 16 | 233 | 187168 | 20100111 | 32714 | [NAME] | 5 | CAS | 10-30 | 3.99 | N
1 | 1 | 33 | 493380 | 20100114 | 37310 | pt | 7 | CAS | 10-30 | 3.99 | N
3 | 23 | 246 | 463201 | 20100108 | 40515 | ra | 1 | CAS | 10-30 | 3.99 | N
2 | 13 | 141 | 306730 | 20100122 | 41085 | cccc | 2 | CAS | 10-30 | 3.99 | N
3 | 19 | 184 | 329293 | 20100108 | 41192 | [NAME] | 12 | CAS | 10-30 | 3.99 | N
3 | 3 | 192 | 323156 | 20100115 | 42801 | kt | 5 | CAS | 10-30 | 3.99 | N
1 | 20 | 236 | 423240 | 20100129 | 43324 | dfsfAdh | 4 | CAS | 10-30 | 3.99 | N
19 | 88 | 1578 | 229424 | 20100108 | 47483 | h | 24 | CAS | 10-30 | 3.99 | N
14 | 83 | 56 | 451868 | 20100105 | 49500 | ghfhfg | 1 | CAS | 10-30 | 3.99 | N
2 | 15 | 203 | 235541 | 20100121 | 50214 | zerwr | 24 | CAS | 10-30 | 3.99 | N
11 | 120 | 1331 | 261701 | 20100111 | 50883 | fhdh | 6 | CAS | 10-30 | 3.99 | N
1 | 4 | 106 | 362505 | 20100107 | 51170 | sfe | 2 | CAS | 10-30 | 3.99 | N
2 | 15 | 264 | 180398 | 20100116 | 52634 | r234 | 1 | CAS | 10-30 | 3.99 | N
2 | 12 | 152 | 109338 | 20100118 | 55013 | 234 | 1 | CAS | 10-30 | 3.99 | N
4 | 35 | 850 | 469389 | 20100126 | 55608 | 342e53246 | 1 | CAS | 10-30 | 3.99 | N
15 | 178 | 1850 | 208486 | 20100121 | 56789 | rtar | 12 | CAS | 10-30 | 3.99 | 1.99 | -2 | 47.88 | 23.88 | -24 | -50.1
15 | 178 | 1850 | 208488 | 20100121 | 56789 | rtar | 12 | CAS | 10-30 | 1.99 | N
1 | 8 | 230 | 210077 | 20100114 | 57008 | dgj f | 6 | CAS | 10-30 | 3.99 | N
1 | 1 | 37 | 407708 | 20100114 | 60497 | fsghfsg | 6 | CAS | 10-30 | 3.99 | N
29 | 238 | 3398 | 143947 | 20100105 | 62738 | hgfhs | 12 | CAS | 10-30 | 3.99 | 2 | -1.99 | 47.88 | 24 | -23.88 | -49.9
29 | 238 | 3398 | 145761 | 20100119 | 62738 | hgfhs | 12 | CAS | 10-30 | 3.99 | 2 | -1.99 | 47.88 | 24 | -23.88 | -49.9
1 | 8 | 129 | 488234 | 20100106 | 63523 | sss | 1 | CAS | 10-30 | 3.99 | N
1 | 8 | 129 | 488463 | 20100108 | 63523 | sss | 1 | CAS | 10-30 | 3.99 | N
1 | 8 | 129 | 488463 | 20100108 | 63523 | sss | 1 | CAS | 10-30 | 3.99 | N
1 | 8 | 870 | 496611 | 20100102 | 69056 | 232141415 | 2 | CAS | 10-30 | 3.99 | N
3 | 19 | 328 | 168113 | 20100109 | 71187 | wrse | 1 | CAS | 10-30 | 3.99 | N
3 | 3 | 194 | 140166 | 20100109 | 77205 | [NAME] | 1 | CAS | 10-30 | 3.99 | N
3 | 29 | 272 | 166034 | 20100111 | 78090 | eyeb | 1 | CAS | 10-30 | 3.99 | 10.99 | 7 | 3.99 | 10.99 | 7 | 175.4
22 | 309 | 1413 | 317853 | 20100121 | 81882 | earwat | 8 | CAS | 10-30 | 3.99 | 2.69 | -1.3 | 31.92 | 21.52 | -10.4 | -32.6
1 | 1 | 42 | 193769 | 20100126 | 82559 | ryerret | 12 | CAS | 10-30 | 3.99 | N
22 | 313 | 2055 | 152517 | 20100102 | 83335 | adfbwea | 12 | CAS | 10-30 | 3.82 | N
1 | 4 | 77 | 355287 | 20100115 | 83758 | 2b52542 | 5 | CAS | 10-30 | 3.99 | N
5 | 36 | 420 | 387505 | 20100121 | 92509 | 5bsrab | 12 | CAS | 10-30 | 3.99 | N
4 | 152 | 416 | 101037 | 20100116 | 93466 | 325234b | 5 | CAS | 10-30 | 3.99 | N
5 | 196 | 404 | 410037 | 20100128 | 94043 | w52q5b5 | 12 | CAS | 10-30 | 3.99 | N
11 | 114 | 2223 | 108518 | 20100104 | 94314 | 3wbr34523b | 7 | CAS | 10-30 | 3.99 | N
5 | 37 | 414 | 345075 | 20100120 | 95039 | 2352536 | 24 | CAS | 10-30 | 3.99 | N
9 | 60 | 593 | 138409 | 20100112 | 95067 | ebterbt | 4 | CAS | 10-30 | 3.99 | 3.49 | -0.5 | 15.96 | 13.96 | -2 | -12.5
8 | 40 | 632 | 105463 | 20100128 | 95140 | teeatb | 12 | CAS | 10-30 | 3.99 | 1.99 | -2 | 47.88 | 23.88 | -24 | -50.1
8 | 40 | 632 | 105493 | 20100128 | 95140 | teeatb | 12 | CAS | 10-30 | 1.99 | N
8 | 62 | 494 | 230162 | 20100104 | 99080 | 53q3bewtr | 1 | CAS | 10-30 | 3.99 | N