Spreadsheet: 707325d1607180860-index-match-formula-not-working-properly-from-data-in-pivot-tables-help-november-mileage-and-fuel
Sheet: Reefer 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.982122905027933 | 8.95 | 13.14 | 2.42 | 2.18
 | 667896 | TA MOBILE | GRAND BAY | AL | 24146 | 2020-11-18 12:43:00 | 2020-11-18 12:43:00 | 1.971311475409836 | 12.2 | 17.78 | 3.29 | 2.98
 | 7006 | PETRO KINGMAN | KINGMAN | AZ | 47139 | 2020-11-21 13:56:00 | 2020-11-21 13:56:00 | 2.313707451701932 | 10.87 | 19.67 | 2.83 | 2.65
 | 667896 | PETRO WHEELER RIDGE | LEBEC | CA | 67867 | 2020-11-21 02:37:00 | 2020-11-21 02:37:00 | 2.926127104834329 | 18.41 | 34.74 | 14.64 | 4.49
 | 7006 | VANCO TRUCK & AUTO PLAZA | STOCKTON | CA | 01012898 | 2020-11-23 06:52:00 | 2020-11-23 06:52:00 | 3.14879467996675 | 24.06 | 50.76 | 19.13 | 5.87
 | 7006 | TA DENVER EAST | COMMERCE CITY | CO | 85761 | 2020-11-27 10:36:00 | 2020-11-27 10:36:00 | 2.140773620798985 | 15.77 | 26.68 | 3.23 | 3.85
 | 01 | TA LIMON | LIMON | CO | 59338 | 2020-11-29 15:41:00 | 2020-11-29 15:41:00 | 2.183783783783784 | 11.1 | 19.25 | 2.28 | 2.71
 | 73 | PETRO OCALA | REDDICK | FL | 45865 | 2020-11-02 09:44:00 | 2020-11-02 09:44:00 | 1.942598187311178 | 9.93 | 13.37 | 3.5 | 2.42
 | 73 | PETRO OCALA | REDDICK | FL | 50394 | 2020-11-04 11:05:00 | 2020-11-04 11:05:00 | 1.955708047411104 | 16.03 | 21.79 | 5.65 | 3.91
 | 667896 | TA VERO BEACH | VERO BEACH | FL | 62604 | 2020-11-11 00:43:00 | 2020-11-11 00:43:00 | 2.097228144989339 | 23.45 | 35.19 | 8.27 | 5.72
 | 667896 | TA VERO BEACH | VERO BEACH | FL | 73148 | 2020-11-17 06:47:00 | 2020-11-17 06:47:00 | 2.078023407022107 | 7.69 | 11.39 | 2.71 | 1.88
 | 667896 | TA CARTERSVILLE | CARTERSVILLE | GA | 90427 | 2020-11-04 12:53:00 | 2020-11-04 12:53:00 | 1.933618843683083 | 9.34 | 12.86 | 2.92 | 2.28
 | 7006 | TA IOWA 80 TRUCKSTOP | WALCOTT | IA | 87030 | 2020-11-08 11:15:00 | 2020-11-08 11:15:00 | 2.021235521235521 | 5.18 | 7.53 | 1.68 | 1.26
 | 7006 | TA IOWA 80 TRUCKSTOP | WALCOTT | IA | 93638 | 2020-11-11 08:51:00 | 2020-11-11 08:51:00 | 2.088345864661654 | 5.32 | 8.08 | 1.73 | 1.3
 | 01 | SAPP BROTHERS | PERCIVAL | IA | 0098232 | 2020-11-11 15:56:00 | 2020-11-11 15:56:00 | 2.092537313432836 | 6.7 | 10.2 | 2.18 | 1.64
 | 73 | TA IOWA 80 TRUCKSTOP | WALCOTT | IA | 95893 | 2020-11-12 06:57:00 | 2020-11-12 06:57:00 | 2.12538860103627 | 9.65 | 15.01 | 3.14 | 2.36
 | 73 | [NAME] | BOISE | ID | 96983 | 2020-11-10 05:45:00 | 2020-11-10 05:45:00 | 2.617073170731708 | 8.2 | 16.84 | 2.62 | 2
 | 667896 | [NAME] | BOISE | ID | 04874 | 2020-11-13 10:34:00 | 2020-11-13 10:34:00 | 2.705053852526926 | 12.07 | 25.84 | 3.86 | 2.95
 | 73 | [NAME] VERNON IL | MT VERNON | IL | 29855 | 2020-11-05 12:44:00 | 2020-11-05 12:44:00 | 2.278427205100956 | 9.41 | 13.39 | 5.75 | 2.3
 | 88 | PETRO SALINA | SALINA | KS | 10209 | 2020-11-01 17:44:00 | 2020-11-01 17:44:00 | 1.77824427480916 | 26.2 | 33.39 | 6.81 | 6.39
 | 7006 | TA SLIDELL | SLIDELL | LA | 72791 | 2020-11-16 19:56:00 | 2020-11-16 19:56:00 | 1.863687150837988 | 26.85 | 38.12 | 5.37 | 6.55
 | 7006 | TA SLIDELL | SLIDELL | LA | 78336 | 2020-11-19 19:11:00 | 2020-11-19 19:11:00 | 1.865965233302836 | 21.86 | 31.09 | 4.37 | 5.33
 | 7006 | [NAME] | [NAME] | MO | 54571 | 2020-11-01 08:16:00 | 2020-11-01 08:16:00 | 1.67268862911796 | 9.41 | 11.84 | 1.6 | 2.3
 | 667896 | [NAME] | FORISTELL | MO | 75247 | 2020-11-08 20:49:00 | 2020-11-08 20:49:00 | 1.884615384615385 | 5.72 | 8.41 | 0.97 | 1.4
 | 667896 | SAPP BROS TRAVEL CENTER | HARRISONVILLE | MO | 0096900 | 2020-11-12 10:39:00 | 2020-11-12 10:39:00 | 1.97790404040404 | 15.84 | 24.77 | 2.69 | 3.87
 | 88 | TA OAK GROVE | OAK GROVE | MO | 15301 | 2020-11-23 15:14:00 | 2020-11-23 15:14:00 | 1.963028169014085 | 28.4 | 43.99 | 4.83 | 6.93
 | 01 | [NAME] | LAUREL | MT | 08212 | 2020-11-13 07:52:00 | 2020-11-13 07:52:00 | 2.250331125827814 | 7.55 | 12.93 | 2.22 | 1.84
 | 01 | TA MISSOULA | MISSOULA | MT | 16690 | 2020-11-14 09:38:00 | 2020-11-14 09:38:00 | 2.317671092951992 | 9.79 | 17.42 | 2.88 | 2.39
 | 667896 | SAPP BROTHERS | SIDNEY | NE | 16018319 | 2020-11-01 12:52:00 | 2020-11-01 12:52:00 | 1.962962962962963 | 14.04 | 19.47 | 4.66 | 3.43
 | 7006 | [NAME] | OGALLALA | NE | 96570 | 2020-11-04 17:05:00 | 2020-11-04 17:05:00 | 1.965340179717587 | 7.79 | 10.82 | 2.59 | 1.9
 | 7006 | [NAME] | OGALLALA | NE | 01657 | 2020-11-08 01:27:00 | 2020-11-08 01:27:00 | 2.034090909090909 | 7.92 | 11.55 | 2.63 | 1.93
 | 667896 | SAPP BROTHERS | SIDNEY | NE | 35010393 | 2020-11-08 04:10:00 | 2020-11-08 04:10:00 | 2.075247524752475 | 15.15 | 22.71 | 5.03 | 3.7
 | 01 | RUSSELLS ENDEE TRUCK & TRAVEL CENTER | SAN JON | NM | 02029308 | 2020-11-18 14:37:00 | 2020-11-18 14:37:00 | 1.99496644295302 | 11.92 | 18.37 | 2.5 | 2.91
 | 7006 | RUSSELLS ENDEE TRUCK & TRAVEL CENTER | SAN JON | NM | 00106967 | 2020-11-20 17:52:00 | 2020-11-20 17:52:00 | 2.044025157232704 | 14.31 | 22.75 | 3.01 | 3.49
 | 7006 | TA MORIARTY | MORIARTY | NM | 84052 | 2020-11-29 14:32:00 | 2020-11-29 14:32:00 | 2.217735550277118 | 12.63 | 22.28 | 2.65 | 3.08
 | 7006 | TA MAYBROOK | MONTGOMERY | NY | 37879 | 2020-11-02 14:45:00 | 2020-11-02 14:45:00 | 1.943868739205527 | 11.58 | 15.22 | 4.46 | 2.83
 | 7006 | TA MAYBROOK | MONTGOMERY | NY | 45486 | 2020-11-09 17:09:00 | 2020-11-10 00:01:00 | 2.939068100358423 | 13.95 | 32.22 | 5.38 | 3.4
 | 1022 | [NAME] | WAPAKONETA | OH | 38913 | 2020-11-03 11:31:00 | 2020-11-03 11:31:00 | 2.13678756476684 | 9.65 | 13.72 | 4.54 | 2.36
 | 1022 | [NAME] | WAPAKONETA | OH | 43004 | 2020-11-05 12:54:00 | 2020-11-05 12:54:00 | 2.177514792899408 | 3.38 | 4.94 | 1.59 | 0.83
 | 1022 | [NAME] | WAPAKONETA | OH | 50208 | 2020-11-10 12:00:00 | 2020-11-10 12:00:00 | 2.236729452054794 | 23.36 | 35.57 | 10.98 | 5.7
 | 73 | TA TOLEDO | PERRYSBURG | OH | 48797 | 2020-11-14 17:41:00 | 2020-11-14 17:41:00 | 2.193362193362193 | 13.86 | 20.51 | 6.51 | 3.38
 | 1022 | [NAME] | WAPAKONETA | OH | 60604 | 2020-11-17 12:58:00 | 2020-11-17 12:58:00 | 2.182006204756981 | 9.67 | 14.19 | 4.55 | 2.36
 | 1022 | [NAME] | WAPAKONETA | OH | 66220 | 2020-11-20 12:00:00 | 2020-11-20 12:00:00 | 2.236818181818181 | 22 | 33.5 | 10.34 | 5.37
 | 99 | TA TOLEDO | PERRYSBURG | OH | 53443 | 2020-11-20 14:43:00 | 2020-11-20 14:43:00 | 2.211071428571429 | 28 | 41.92 | 13.16 | 6.83
 | 88 | PETRO OKLAHOMA CITY | OKLAHOMA CITY | OK | 17797 | 2020-11-10 10:30:00 | 2020-11-10 10:30:00 | 1.82136678200692 | 23.12 | 32.08 | 4.39 | 5.64
 | 01 | PETRO OKLAHOMA CITY | OKLAHOMA CITY | OK | 18081 | 2020-11-10 13:51:00 | 2020-11-10 13:51:00 | 1.820785597381342 | 12.22 | 16.95 | 2.32 | 2.98
 | 01 | TA OKLAHOMA CITY WEST | OKLAHOMA CITY | OK | 89497 | 2020-11-20 05:47:00 | 2020-11-20 05:47:00 | 1.943911439114391 | 13.55 | 20.45 | 2.58 | 3.31
 | 667896 | TA OKLAHOMA CITY EAST | OKLAHOMA CITY | OK | 24592 | 2020-11-22 03:24:00 | 2020-11-22 03:24:00 | 1.95566037735849 | 10.6 | 16.13 | 2.01 | 2.59
 | 7006 | TA EXPRESS BIGGS JUNCTION | [NAME] | OR | 18444 | 2020-11-05 12:28:00 | 2020-11-05 12:28:00 | 1.9812734082397 | 8.01 | 13.92 | 0 | 1.95
 | 7006 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0098103 | 2020-11-07 06:12:00 | 2020-11-07 06:12:00 | 1.888402625820569 | 13.71 | 22.54 | 0 | 3.35
 | 88 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0098917 | 2020-11-12 18:31:00 | 2020-11-12 18:31:00 | 2.039263803680982 | 16.3 | 29.26 | 0 | 3.98
 | 667896 | ARROWHEAD TRUCK STOP | PENDLETON | OR | 0099013 | 2020-11-14 18:01:00 | 2020-11-14 18:01:00 | 2.129496402877697 | 6.95 | 13.1 | 0 | 1.7
 | 01 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0099314 | 2020-11-16 17:53:00 | 2020-11-16 17:53:00 | 2.148854961832061 | 10.48 | 19.96 | 0 | 2.56
 | 7006 | TA PORTLAND | AURORA | OR | 45491 | 2020-11-25 01:03:00 | 2020-11-25 01:03:00 | 2.05730659025788 | 3.49 | 6.33 | 0 | 0.85
 | 7006 | SPACE AGE TRAVEL CENTER | HERMISTON | OR | 0090704 | 2020-11-25 18:09:00 | 2020-11-25 18:09:00 | 2.07185628742515 | 3.34 | 6.1 | 0 | 0.82
 | 01 | COMMON CENTS #125 | RAPID CITY | SD | 0096414 | 2020-11-12 13:20:00 | 2020-11-12 13:20:00 | 2.206611570247934 | 6.05 | 10.18 | 1.69 | 1.48
 | 73 | TA NASHVILLE | NASHVILLE | TN | 86068 | 2020-11-01 11:43:00 | 2020-11-01 11:43:00 | 1.888760139049826 | 17.26 | 23.73 | 4.66 | 4.21
 | 667896 | TA ANTIOCH | ANTIOCH | TN | 89560 | 2020-11-02 10:27:00 | 2020-11-02 10:27:00 | 1.89459815546772 | 7.59 | 10.48 | 2.05 | 1.85
 | 01 | PETRO AMARILLO | [NAME] | TX | 99028 | 2020-11-01 07:58:00 | 2020-11-01 07:58:00 | 1.786106032906764 | 5.47 | 7.34 | 1.09 | 1.34
 | 88 | PETRO AMARILLO | [NAME] | TX | 13436 | 2020-11-08 17:30:00 | 2020-11-08 17:30:00 | 1.892762186115214 | 33.85 | 49.04 | 6.77 | 8.26
 | 667896 | TA AMARILLO | [NAME] | TX | 26794 | 2020-11-15 20:20:00 | 2020-11-15 20:20:00 | 1.978782287822878 | 10.84 | 16.63 | 2.17 | 2.65
 | 88 | PETRO AMARILLO | [NAME] | TX | 28255 | 2020-11-16 13:30:00 | 2020-11-16 13:30:00 | 1.979184013322231 | 24.02 | 36.88 | 4.8 | 5.86
 | 667896 | LOVES #542 TRAVEL STOP | FT STOCKTON | TX | 93990 | 2020-11-19 07:01:00 | 2020-11-19 07:01:00 | 2.450516986706056 | 6.77 | 13.59 | 1.35 | 1.65
 | 7006 | TA TERRELL | TERRELL | TX | 46768 | 2020-11-28 07:29:00 | 2020-11-28 07:29:00 | 2.03485254691689 | 7.46 | 11.87 | 1.49 | 1.82
 | 01 | TA DALLAS SOUTH | DALLAS | TX | 48819 | 2020-11-28 15:03:00 | 2020-11-28 15:03:00 | 2.030082041932543 | 10.97 | 17.4 | 2.19 | 2.68
 | 01 | RJ FUEL STOP | TREMONTON | UT | 0090334 | 2020-11-17 11:12:00 | 2020-11-17 11:12:00 | 2.588832487309644 | 5.91 | 12.02 | 1.84 | 1.44
 | 01 | RJ FUEL STOP | TREMONTON | UT | 0093199 | 2020-11-30 12:50:00 | 2020-11-30 12:50:00 | 2.588325652841782 | 6.51 | 13.23 | 2.03 | 1.59
 | 88 | PETRO GLADE SPRING | GLADE SPRING | VA | 15986 | 2020-11-20 10:42:00 | 2020-11-20 10:42:00 | 2.094038325053229 | 28.18 | 46.44 | 5.69 | 6.88
 | 88 | TA SEATTLE EAST | NORTH BEND | WA | 72996 | 2020-11-05 08:51:00 | 2020-11-05 08:51:00 | 2.399849680571214 | 26.61 | 44.22 | 13.15 | 6.49
 | 7006 | TA WHEELING | VALLEY GROVE | WV | 16818 | 2020-11-03 21:48:00 | 2020-11-03 21:48:00 | 1.943886097152429 | 11.94 | 16.04 | 4.26 | 2.91
 | 73 | TA CHEYENNE | CHEYENNE | WY | 85526 | 2020-11-06 16:41:00 | 2020-11-06 16:41:00 | 2.198521647307285 | 9.47 | 16.24 | 2.27 | 2.31