Spreadsheet: 858469d1707149241-create-billing-tool-sample-file
Sheet: Sheet2

CONCAT | Class | Tier | MIN 1-150 | MIN 151+ | 1-499 | 500-999 | 1000-1999 | 2000-4999 | 5000-9999 | 10000+ |  |  | Advertised Rate
 | 50 | A | 78 | 78 | 23.46 | 15.25 | 10.92 | 7.94 | 5.64 | 4.17 |  |  | Zone | Weight | Class | Rate | Total | MIN Charge | Zone, Weight, and Class are manually input and the Rate is pulled from a separate table, independent of the problem I currently having.
 | 50 | B | 143 | 143 | 53.27 | 37.04 | 27.86 | 20.94 | 15.59 | 11.53 |  |  | 120 | 171 | 60 | 293.55 |  | False
 | 50 | C | 216 | 216 | 86.04 | 61.7 | 47.58 | 36.63 | 27.44 | 20.51 |  |  |  |  | X
 | 50 | D | 293 | 293 | 121.82 | 89.54 | 70.4 | 54.9 | 41.52 | 31.01
 | 50 | E | 366 | 366 | 158.66 | 118.46 | 94.19 | 74.03 | 56.22 | 42.1 |  |  | Shipping Bill
 | 50 | F | 311 | 311 | 105.18 | 64.86 | 44.59 | 32.25 | 24.77 | 20.14 |  |  | Zone | Weight | Class | Rate | Total
 | 50 | G | 429 | 429 | 153.81 | 96.72 | 68.56 | 51.26 | 40.94 | 33.84 |  |  |  |  |  | 403.31 |  |  | When we have a discrepancy from the bill received we manually input the Rate into Q8
 | 50 | H | 707 | 707 | 317.32 | 218.36 | 171.05 | 140.87 | 120.79 | 103 |  |  |  |  | X
 | 50 | I | 960 | 960 | 588.34 | 444.23 | 378.4 | 331.75 | 296.09 | 256.48
 | 55 | A | 78 | 78 | 23.97 | 15.59 | 11.16 | 8.2 | 5.77 | 4.31 |  |  | Difference in Charge vs Rate
 | 55 | B | 143 | 143 | 54.43 | 37.85 | 28.47 | 21.64 | 15.93 | 11.91 |  |  |  |  |  | G25 |  | This subtracts Q9 - Q4 to find the discrepancy in price.
 | 55 | C | 216 | 216 | 87.91 | 63.05 | 48.63 | 37.85 | 28.05 | 21.21
 | 55 | D | 293 | 293 | 124.47 | 91.51 | 71.94 | 56.73 | 42.44 | 32.05 |  |  | Base Rate Charge Identifier
 | 55 | E | 366 | 366 | 162.11 | 121.07 | 96.26 | 76.5 | 57.47 | 43.52 |  |  | Tier Listed Charge | [NAME]? | Class | [NAME] is
 | 55 | F | 311 | 311 | 107.47 | 66.29 | 45.57 | 33.32 | 25.32 | 20.82 |  |  | 109.76 |  |  | F | I need this cell to find C25
 | 55 | G | 429 | 429 | 157.15 | 98.85 | 70.07 | 52.96 | 41.85 | 34.98 |  |  | I need this cell to find F25 specifically from the classs range entered into P16
 | 55 | H | 707 | 707 | 324.22 | 223.16 | 174.81 | 145.56 | 123.47 | 106.47
 | 55 | I | 960 | 960 | 601.13 | 454 | 386.71 | 342.81 | 302.67 | 265.13 |  |  | There are multiple shipping classes (50 to 400) that the table to the left is a sample of. These represent upcharges to the shipping charge that gets tacked onto the shipping rate. Do I make them separate tables or combine them?
 | 60 | A | 78 | 78 | 24.48 | 16.09 | 11.4 | 8.38 | 5.96 | 4.45
 | 60 | B | 143 | 143 | 55.58 | 39.07 | 29.08 | 22.11 | 16.45 | 12.3
 | 60 | C | 216 | 216 | 89.78 | 65.09 | 49.68 | 38.67 | 28.97 | 21.9
 | 60 | D | 293 | 293 | 127.11 | 94.46 | 73.49 | 57.95 | 43.82 | 33.1
 | 60 | E | 366 | 366 | 165.56 | 124.97 | 98.33 | 78.15 | 59.35 | 44.94
 | 60 | F | 311 | 311 | 109.76 | 68.43 | 46.55 | 34.04 | 26.14 | 21.5
 | 60 | G | 429 | 429 | 160.49 | 102.04 | 71.57 | 54.1 | 43.22 | 36.12
 | 60 | H | 707 | 707 | 331.11 | 230.36 | 178.57 | 148.69 | 127.5 | 109.94
 | 60 | I | 960 | 960 | 613.92 | 468.64 | 395.03 | 350.18 | 312.54 | 273.77
 | 65 | A | 78 | 78 | 24.99 | 16.42 | 11.76 | 8.64 | 6.08 | 4.54
 | 65 | B | 143 | 143 | 56.74 | 39.89 | 30 | 22.8 | 16.8 | 12.56
 | 65 | C | 216 | 216 | 91.65 | 66.44 | 51.24 | 39.89 | 29.58 | 22.36
 | 65 | D | 293 | 293 | 129.76 | 96.43 | 75.81 | 59.78 | 44.75 | 33.79
 | 65 | E | 366 | 366 | 169.01 | 127.58 | 101.44 | 80.61 | 60.6 | 45.88
 | 65 | F | 311 | 311 | 112.04 | 69.85 | 48.02 | 35.11 | 26.69 | 21.95
 | 65 | G | 429 | 429 | 163.84 | 104.16 | 73.83 | 55.81 | 44.13 | 36.88
 | 65 | H | 707 | 707 | 338.01 | 235.16 | 184.21 | 153.39 | 130.18 | 112.26
 | 65 | I | 960 | 960 | 626.71 | 478.41 | 407.5 | 361.24 | 319.12 | 279.53