Spreadsheet: 707237d1607113443-index-match-formula-not-working-properly-from-data-in-pivot-tables-help-november-mileage-and-fuel
Sheet: Gallons Rpt - Nov

 | Unit | Location Name | City | State/Province | Invoice | Post Date | Tran Date | PPU | Volume | Amount | State Tax | Federal Tax
 | 667896 | TA MOBILE | GRAND BAY | AL | 20678 | 2020-11-16 12:44:00 | 2020-11-16 12:44:00 | 1.982017573734759 | 146.81 | 215.52 | 39.64 | 35.82
 | 667896 | TA MOBILE | GRAND BAY | AL | 24146 | 2020-11-18 12:43:00 | 2020-11-18 12:43:00 | 1.971028829847371 | 141.52 | 206.2 | 38.21 | 34.53
 | 88 | PETRO WEST MEMPHIS | WEST MEMPHIS | AR | 13691 | 2020-11-19 12:05:00 | 2020-11-19 12:05:00 | 2.039032258064517 | 31 | 46.81 | 8.84 | 7.56
 | 7006 | PETRO KINGMAN | KINGMAN | AZ | 47139 | 2020-11-21 13:56:00 | 2020-11-21 13:56:00 | 2.313024370755094 | 100.12 | 181.12 | 26.03 | 24.43
 | 667896 | PETRO WHEELER RIDGE | LEBEC | CA | 67867 | 2020-11-21 02:37:00 | 2020-11-21 02:37:00 | 2.92595367422114 | 160.17 | 302.23 | 127.34 | 39.08
 | 88 | TA LIMON | LIMON | CO | 46672 | 2020-11-08 11:37:00 | 2020-11-08 11:37:00 | 2.03903260370427 | 65.33 | 103.88 | 13.39 | 15.94
 | 7006 | TA DENVER EAST | COMMERCE CITY | CO | 85761 | 2020-11-27 10:36:00 | 2020-11-27 10:36:00 | 2.141028376360145 | 187.48 | 317.22 | 38.43 | 45.75
 | 01 | TA LIMON | LIMON | CO | 59338 | 2020-11-29 15:41:00 | 2020-11-29 15:41:00 | 2.184031028487361 | 74.77 | 129.73 | 15.33 | 18.24
 | 2907 | PETRO JOHNSTOWN | JOHNSTOWN | CO | 24600 | 2020-11-30 15:12:00 | 2020-11-30 15:12:00 | 2.184980142014683 | 83.09 | 144.25 | 17.03 | 20.27
 | 73 | PETRO OCALA | REDDICK | FL | 45865 | 2020-11-02 09:44:00 | 2020-11-02 09:44:00 | 1.94201104551514 | 105.02 | 141.28 | 37.04 | 25.63
 | 73 | PETRO OCALA | REDDICK | FL | 50394 | 2020-11-04 11:05:00 | 2020-11-04 11:05:00 | 1.955981506453477 | 103.82 | 141.12 | 36.62 | 25.33
 | 667896 | TA VERO BEACH | VERO BEACH | FL | 62604 | 2020-11-11 00:43:00 | 2020-11-11 00:43:00 | 2.096957634347455 | 175.85 | 263.82 | 62.02 | 42.91
 | 667896 | TA MARIANNA | MARIANNA | FL | 29434 | 2020-11-11 17:29:00 | 2020-11-11 17:29:00 | 2.035038867618053 | 86.19 | 123.97 | 30.4 | 21.03
 | 667896 | TA VERO BEACH | VERO BEACH | FL | 73148 | 2020-11-17 06:47:00 | 2020-11-17 06:47:00 | 2.078044266214237 | 129.67 | 192.08 | 45.74 | 31.64
 | 667896 | TA CARTERSVILLE | CARTERSVILLE | GA | 90427 | 2020-11-04 12:53:00 | 2020-11-04 12:53:00 | 1.933987925429576 | 150.73 | 207.55 | 47.18 | 36.78
 | 7006 | TA IOWA 80 TRUCKSTOP | WALCOTT | IA | 87030 | 2020-11-08 11:15:00 | 2020-11-08 11:15:00 | 2.021011750647281 | 100.42 | 145.81 | 32.64 | 24.5
 | 7006 | TA IOWA 80 TRUCKSTOP | WALCOTT | IA | 93638 | 2020-11-11 08:51:00 | 2020-11-11 08:51:00 | 2.087975354780061 | 198.01 | 300.78 | 64.35 | 48.31
 | 01 | SAPP BROTHERS | PERCIVAL | IA | 0098232 | 2020-11-11 15:56:00 | 2020-11-11 15:56:00 | 2.090940565493364 | 86.65 | 131.88 | 28.16 | 21.14
 | 73 | TA IOWA 80 TRUCKSTOP | WALCOTT | IA | 95893 | 2020-11-12 06:57:00 | 2020-11-12 06:57:00 | 2.125025085289986 | 99.66 | 155.07 | 32.39 | 24.32
 | 88 | [NAME] | BOISE | ID | 83846 | 2020-11-04 11:49:00 | 2020-11-04 11:49:00 | 2.464055913024185 | 90.14 | 171.27 | 28.85 | 21.99
 | 73 | [NAME] | BOISE | ID | 96983 | 2020-11-10 05:45:00 | 2020-11-10 05:45:00 | 2.617029862792574 | 123.9 | 254.37 | 39.65 | 30.23
 | 667896 | [NAME] | BOISE | ID | 04874 | 2020-11-13 10:34:00 | 2020-11-13 10:34:00 | 2.704979536152797 | 117.28 | 251.09 | 37.53 | 28.62
 | 88 | [NAME] | BOISE | ID | 07455 | 2020-11-14 14:41:00 | 2020-11-14 14:41:00 | 2.706998571720058 | 98.02 | 210.05 | 31.37 | 23.92
 | 7006 | [NAME] | BOISE | ID | 08171 | 2020-11-14 21:41:00 | 2020-11-14 21:41:00 | 2.707008086253369 | 111.3 | 238.51 | 35.62 | 27.16
 | 73 | [NAME] VERNON IL | MT VERNON | IL | 29855 | 2020-11-05 12:44:00 | 2020-11-05 12:44:00 | 2.277958658287272 | 132.07 | 187.92 | 80.7 | 32.23
 | 88 | PETRO SALINA | SALINA | KS | 10209 | 2020-11-01 17:44:00 | 2020-11-01 17:44:00 | 1.777953270519035 | 183.61 | 233.91 | 47.74 | 44.8
 | 7006 | TA SLIDELL | SLIDELL | LA | 72791 | 2020-11-16 19:56:00 | 2020-11-16 19:56:00 | 1.864035638097628 | 159.38 | 226.32 | 31.88 | 38.89
 | 7006 | TA SLIDELL | SLIDELL | LA | 78336 | 2020-11-19 19:11:00 | 2020-11-19 19:11:00 | 1.866000296897422 | 202.09 | 287.37 | 40.42 | 49.31
 | 7006 | [NAME] | [NAME] | MO | 54571 | 2020-11-01 08:16:00 | 2020-11-01 08:16:00 | 1.673022819631135 | 95.97 | 120.82 | 16.32 | 23.42
 | 667896 | [NAME] | FORISTELL | MO | 75247 | 2020-11-08 20:49:00 | 2020-11-08 20:49:00 | 1.885002010454363 | 124.35 | 182.92 | 21.14 | 30.34
 | 667896 | SAPP BROS TRAVEL CENTER | HARRISONVILLE | MO | 0096900 | 2020-11-12 10:39:00 | 2020-11-12 10:39:00 | 1.977979704185183 | 150.77 | 235.8 | 25.63 | 36.79
 | 88 | TA OAK GROVE | OAK GROVE | MO | 15301 | 2020-11-23 15:14:00 | 2020-11-23 15:14:00 | 1.962988977739356 | 185.08 | 286.69 | 31.46 | 45.16
 | 667896 | [NAME] | LAUREL | MT | 01949 | 2020-11-06 01:32:00 | 2020-11-06 01:32:00 | 2.16103267446551 | 123.95 | 201.12 | 36.5 | 30.24
 | 7006 | [NAME] | LAUREL | MT | 07369 | 2020-11-12 09:10:00 | 2020-11-12 09:10:00 | 2.258016660960859 | 175.26 | 301.37 | 51.61 | 42.76
 | 01 | [NAME] | LAUREL | MT | 08212 | 2020-11-13 07:52:00 | 2020-11-13 07:52:00 | 2.250026758000642 | 93.43 | 159.9 | 27.52 | 22.8
 | 01 | TA MISSOULA | MISSOULA | MT | 16690 | 2020-11-14 09:38:00 | 2020-11-14 09:38:00 | 2.316963713296576 | 77.99 | 138.7 | 22.97 | 19.03
 | 667896 | SAPP BROTHERS | SIDNEY | NE | 16018319 | 2020-11-01 12:52:00 | 2020-11-01 12:52:00 | 1.962974759136874 | 125.59 | 174.19 | 41.7 | 30.64
 | 7006 | [NAME] | OGALLALA | NE | 96570 | 2020-11-04 17:05:00 | 2020-11-04 17:05:00 | 1.965002046663938 | 195.44 | 271.46 | 64.89 | 47.69
 | 73 | [NAME] | OGALLALA | NE | 99239 | 2020-11-06 13:50:00 | 2020-11-06 13:50:00 | 2.03103378786861 | 148.87 | 216.61 | 49.43 | 36.32
 | 7006 | [NAME] | OGALLALA | NE | 01657 | 2020-11-08 01:27:00 | 2020-11-08 01:27:00 | 2.034016132455954 | 188.44 | 274.75 | 62.56 | 45.98
 | 667896 | SAPP BROTHERS | SIDNEY | NE | 35010393 | 2020-11-08 04:10:00 | 2020-11-08 04:10:00 | 2.074958766990843 | 175.83 | 263.56 | 58.38 | 42.9
 | 73 | [NAME] | OGALLALA | NE | 05979 | 2020-11-11 08:06:00 | 2020-11-11 08:06:00 | 2.090039467522911 | 149.49 | 226.33 | 49.63 | 36.48
 | 73 | [NAME] | [NAME] | NH | 01940 | 2020-11-15 17:33:00 | 2020-11-15 17:33:00 | 1.965002499821441 | 140.01 | 209.88 | 31.08 | 34.16
 | 88 | TA ALBUQUERQUE | ALBUQUERQUE | NM | 83524 | 2020-11-11 10:08:00 | 2020-11-11 10:08:00 | 2.055999148301927 | 93.93 | 150.47 | 19.73 | 22.92
 | 7006 | TA MORIARTY | MORIARTY | NM | 52795 | 2020-11-16 01:57:00 | 2020-11-16 01:57:00 | 2.081010978405115 | 165.78 | 269.73 | 34.81 | 40.45
 | 88 | TA MORIARTY | MORIARTY | NM | 53359 | 2020-11-16 09:08:00 | 2020-11-16 09:08:00 | 2.080983606557377 | 30.5 | 49.62 | 6.41 | 7.44
 | 01 | RUSSELLS ENDEE TRUCK & TRAVEL CENTER | SAN JON | NM | 02029308 | 2020-11-18 14:37:00 | 2020-11-18 14:37:00 | 1.995025262339681 | 128.65 | 198.25 | 27.02 | 31.39
 | 7006 | RUSSELLS ENDEE TRUCK & TRAVEL CENTER | SAN JON | NM | 00106967 | 2020-11-20 17:52:00 | 2020-11-20 17:52:00 | 2.043998639918395 | 147.05 | 233.81 | 30.88 | 35.88
 | 7006 | TA MORIARTY | MORIARTY | NM | 84052 | 2020-11-29 14:32:00 | 2020-11-29 14:32:00 | 2.21698356263204 | 194.07 | 342.14 | 40.76 | 47.35
 | 7006 | TA MAYBROOK | MONTGOMERY | NY | 37879 | 2020-11-02 14:45:00 | 2020-11-02 14:45:00 | 1.943997071742313 | 191.24 | 251.39 | 73.72 | 46.66
 | 7006 | TA MAYBROOK | MONTGOMERY | NY | 45486 | 2020-11-09 17:09:00 | 2020-11-10 00:01:00 | 2.938922852983988 | 171.75 | 396.64 | 66.21 | 41.91
 | 1022 | [NAME] | WAPAKONETA | OH | 38913 | 2020-11-03 11:31:00 | 2020-11-03 11:31:00 | 2.136000851335532 | 187.94 | 267.25 | 88.33 | 45.86
 | 1022 | [NAME] | WAPAKONETA | OH | 43004 | 2020-11-05 12:54:00 | 2020-11-05 12:54:00 | 2.174943090801788 | 118.61 | 173.28 | 55.75 | 28.94
 | 1022 | [NAME] | WAPAKONETA | OH | 50208 | 2020-11-10 12:00:00 | 2020-11-10 12:00:00 | 2.237000393501603 | 177.89 | 270.92 | 83.61 | 43.41
 | 1022 | [NAME] | WAPAKONETA | OH | 53798 | 2020-11-12 12:53:00 | 2020-11-12 12:53:00 | 2.295977461261543 | 127.78 | 202.14 | 60.06 | 31.18
 | 73 | TA TOLEDO | PERRYSBURG | OH | 48797 | 2020-11-14 17:41:00 | 2020-11-14 17:41:00 | 2.194017998941238 | 151.12 | 223.66 | 71.03 | 36.87
 | 1022 | [NAME] | WAPAKONETA | OH | 58824 | 2020-11-16 12:07:00 | 2020-11-16 12:07:00 | 2.197038420490929 | 74.96 | 111.17 | 35.23 | 18.29
 | 1022 | [NAME] | WAPAKONETA | OH | 60604 | 2020-11-17 12:58:00 | 2020-11-17 12:58:00 | 2.182026330852891 | 192.17 | 282.11 | 90.32 | 46.89
 | 1022 | [NAME] | WAPAKONETA | OH | 66220 | 2020-11-20 12:00:00 | 2020-11-20 12:00:00 | 2.236975660279648 | 193.1 | 294.08 | 90.76 | 47.12
 | 667896 | LOVES #690 TRAVEL STOP | CIRCLEVILLE | OH | 59920 | 2020-11-30 12:51:00 | 2020-11-30 12:51:00 | 2.629063097514341 | 146.44 | 280.44 | 68.83 | 35.73
 | 88 | PETRO OKLAHOMA CITY | OKLAHOMA CITY | OK | 17797 | 2020-11-10 10:30:00 | 2020-11-10 10:30:00 | 1.820965272741923 | 124.11 | 172.14 | 23.58 | 30.28
 | 01 | PETRO OKLAHOMA CITY | OKLAHOMA CITY | OK | 18081 | 2020-11-10 13:51:00 | 2020-11-10 13:51:00 | 1.821039903264812 | 99.24 | 137.64 | 18.86 | 24.22
 | 01 | TA OKLAHOMA CITY WEST | OKLAHOMA CITY | OK | 89497 | 2020-11-20 05:47:00 | 2020-11-20 05:47:00 | 1.943936092955701 | 68.85 | 103.96 | 13.08 | 16.8
 | 667896 | TA OKLAHOMA CITY EAST | OKLAHOMA CITY | OK | 24592 | 2020-11-22 03:24:00 | 2020-11-22 03:24:00 | 1.956021118849697 | 178.04 | 270.98 | 33.83 | 43.44
 | 01 | PETRO OKLAHOMA CITY | OKLAHOMA CITY | OK | 33825 | 2020-11-22 07:40:00 | 2020-11-22 07:40:00 | 1.956020116359334 | 101.41 | 154.35 | 19.27 | 24.74
 | 7006 | TA EXPRESS BIGGS JUNCTION | [NAME] | OR | 18444 | 2020-11-05 12:28:00 | 2020-11-05 12:28:00 | 1.981028484453142 | 183.96 | 319.54 | 0 | 44.89
 | 7006 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0098103 | 2020-11-07 06:12:00 | 2020-11-07 06:12:00 | 1.888996450467893 | 92.97 | 152.93 | 0 | 22.69
 | 667896 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0098113 | 2020-11-07 09:32:00 | 2020-11-07 09:32:00 | 1.888979315022042 | 147.45 | 242.55 | 0 | 35.98
 | 73 | ARROWHEAD TRUCK STOP | PENDLETON | OR | 0098049 | 2020-11-09 06:45:00 | 2020-11-09 06:45:00 | 1.96903522988996 | 117.23 | 202.23 | 0 | 28.6
 | 88 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0098917 | 2020-11-12 18:31:00 | 2020-11-12 18:31:00 | 2.038980420248329 | 167.52 | 300.69 | 0 | 40.88
 | 7006 | TA EXPRESS BIGGS JUNCTION | [NAME] | OR | 32467 | 2020-11-14 04:47:00 | 2020-11-14 04:47:00 | 2.180041947234794 | 181.18 | 350.77 | 0 | 44.21
 | 667896 | ARROWHEAD TRUCK STOP | PENDLETON | OR | 0099013 | 2020-11-14 18:01:00 | 2020-11-14 18:01:00 | 2.129039222741993 | 138.95 | 261.93 | 0 | 33.9
 | 01 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0099314 | 2020-11-16 17:53:00 | 2020-11-16 17:53:00 | 2.148978531855956 | 115.52 | 220.06 | 0 | 28.19
 | 7006 | TA PORTLAND | AURORA | OR | 45491 | 2020-11-25 01:03:00 | 2020-11-25 01:03:00 | 2.055995355710365 | 189.48 | 343.34 | 0 | 46.23
 | 7006 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0090704 | 2020-11-25 18:09:00 | 2020-11-25 18:09:00 | 2.072099517644072 | 78.78 | 144.02 | 0 | 19.22
 | 667896 | TA EXPRESS VERMILLION | BURBANK | SD | 99862 | 2020-11-05 06:40:00 | 2020-11-05 06:40:00 | 1.942010149771011 | 161.58 | 229.12 | 45.24 | 39.43
 | 01 | COMMON CENTS #125 | RAPID CITY | SD | 0096414 | 2020-11-12 13:20:00 | 2020-11-12 13:20:00 | 2.209006531454108 | 58.18 | 98.03 | 16.29 | 14.2
 | 73 | TA NASHVILLE | NASHVILLE | TN | 86068 | 2020-11-01 11:43:00 | 2020-11-01 11:43:00 | 1.889041989992023 | 137.89 | 189.6 | 37.23 | 33.65
 | 667896 | TA ANTIOCH | ANTIOCH | TN | 89560 | 2020-11-02 10:27:00 | 2020-11-02 10:27:00 | 1.895015780384684 | 167.93 | 231.91 | 45.34 | 40.98
 | 01 | PETRO AMARILLO | [NAME] | TX | 99028 | 2020-11-01 07:58:00 | 2020-11-01 07:58:00 | 1.78609728073535 | 52.22 | 70.09 | 10.44 | 12.74
 | 88 | PETRO AMARILLO | [NAME] | TX | 13436 | 2020-11-08 17:30:00 | 2020-11-08 17:30:00 | 1.893016793524224 | 165.54 | 239.87 | 33.11 | 40.39
 | 667896 | TA AMARILLO | [NAME] | TX | 26794 | 2020-11-15 20:20:00 | 2020-11-15 20:20:00 | 1.97903036403288 | 119.22 | 183.01 | 23.84 | 29.09
 | 88 | PETRO AMARILLO | [NAME] | TX | 28255 | 2020-11-16 13:30:00 | 2020-11-16 13:30:00 | 1.978992401506928 | 156.61 | 240.4 | 31.32 | 38.21
 | 667896 | LOVES #542 TRAVEL STOP | FT STOCKTON | TX | 93990 | 2020-11-19 07:01:00 | 2020-11-19 07:01:00 | 2.449044082793491 | 126.58 | 253.79 | 25.32 | 30.89
 | 7006 | TA TERRELL | TERRELL | TX | 46768 | 2020-11-28 07:29:00 | 2020-11-28 07:29:00 | 2.035022692889562 | 132.2 | 210.33 | 26.44 | 32.26
 | 01 | TA DALLAS SOUTH | DALLAS | TX | 48819 | 2020-11-28 15:03:00 | 2020-11-28 15:03:00 | 2.030008110300081 | 61.65 | 97.78 | 12.33 | 15.04
 | 01 | PETRO AMARILLO | [NAME] | TX | 50324 | 2020-11-29 09:26:00 | 2020-11-29 09:26:00 | 2.109953703703704 | 77.76 | 129.55 | 15.55 | 18.97
 | 667896 | MILLERS WELLINGTON | TREMONTON | UT | 0099294 | 2020-11-15 07:01:00 | 2020-11-15 07:01:00 | 2.588979832925491 | 118.51 | 241.04 | 36.86 | 28.92
 | 01 | RJ FUEL STOP | TREMONTON | UT | 0090334 | 2020-11-17 11:12:00 | 2020-11-17 11:12:00 | 2.58895772198674 | 92.01 | 187.14 | 28.62 | 22.45
 | 01 | RJ FUEL STOP | TREMONTON | UT | 0093199 | 2020-11-30 12:50:00 | 2020-11-30 12:50:00 | 2.589044997152079 | 105.34 | 214.27 | 32.76 | 25.7
 | 88 | PETRO GLADE SPRING | GLADE SPRING | VA | 15986 | 2020-11-20 10:42:00 | 2020-11-20 10:42:00 | 2.094007253468424 | 173.71 | 286.27 | 35.09 | 42.39
 | 88 | TA-PETRO LEXINGTON | LEXINGTON | VA | 60535 | 2020-11-22 13:01:00 | 2020-11-22 13:01:00 | 2.035134753774516 | 70.87 | 112.62 | 14.32 | 17.29
 | 88 | TA SEATTLE EAST | NORTH BEND | WA | 72996 | 2020-11-05 08:51:00 | 2020-11-05 08:51:00 | 2.400011492931847 | 174.02 | 289.22 | 85.97 | 42.46
 | 7006 | TA WHEELING | VALLEY GROVE | WV | 16818 | 2020-11-03 21:48:00 | 2020-11-03 21:48:00 | 1.943999452317382 | 146.07 | 196.17 | 52.15 | 35.64
 | 88 | TA - FT BRIDGER #188 | FT BRIDGER | WY | 96910 | 2020-11-07 15:05:00 | 2020-11-07 19:15:00 | 2.511019283746556 | 65.34 | 132.45 | 15.68 | 15.94
 | 73 | TA - FT BRIDGER #188 | FT BRIDGER | WY | 99166 | 2020-11-08 16:38:00 | 2020-11-08 16:38:00 | 2.510973329396713 | 101.61 | 205.96 | 24.39 | 24.79
 | 667896 | TA CHEYENNE | CHEYENNE | WY | 92821 | 2020-11-12 21:42:00 | 2020-11-12 21:42:00 | 2.319023569023569 | 118.8 | 218 | 28.51 | 28.99