Spreadsheet: 724032d1615992558-matching-multiple-criteria-rate-card-test
Sheet: Data 

 |  |  | Details | Quantity |  | [NAME] | Cost |  | Cost | Band |  | Rate | Fuel surcharge | Fuel cost | Total
 |  |  | Grantham | 22 | 353.66 | 44.1 | 397.76 |  | 810.7 | #N/A |  | 36.85 | 0.0425 | 34.45475
 |  |  | South Bank | 2 | 136.92 | 17.07 | 153.99 |  | 166.62 | 0 |  | 83.31 |  | 7.08135
 |  |  | Leeming Bar | 1 | 68.94 | 8.6 | 77.54 |  | 97.42 | #N/A |  | 97.42 |  | 4.140350000000001
 |  |  | Ellesmere | 1 | 68.94 | 8.6 | 77.54 |  | 86.42 | D |  | 86.42 |  | 3.67285
 |  |  | [NAME] | 1 | 53.26 | 6.64 | 59.9 |  | 91.14 | D |  | 91.14 |  | 3.87345
 |  |  | Tunstead | 25 | 260 | 32.42 | 292.42 |  | 165 | A
 |  |  | Peterborough | 22 | 217.26 | 27.09 | 244.35 |  | 528.6600000000001 | #N/A |  | 24.03 |  | 22.46805000000001
 |  |  | Evesham | 1 | 60.74 | 7.57 | 68.31 |  | 86.42 | C |  | 86.42 |  | 3.67285
 |  |  | Chesterfield | 1 | 60.74 | 7.57 | 68.31 |  | 86.42 | C |  | 86.42 |  | 3.67285
 |  |  | Carlisle | 4 | 263.76 | 32.89 | 296.65 |  | 301.2 | E |  | 75.3 |  | 12.801
 |  |  | Swansea | 1 | 74.83 | 9.33 | 84.16 |  | 91.14 | D |  | 91.14 |  | 3.87345
 |  |  | Southall | 5 | 171.2 | 21.35 | 192.55 |  | 296.4 | C |  | 59.28 |  | 12.597
 |  |  | [NAME] (Norish) | 6 | 194.88 | 24.3 | 219.18 |  | 317.22 | C |  | 52.87 |  | 13.48185
 |  |  | Grimsby | 12 | 242.52 | 30.24 | 272.76 |  | 442.2 | C |  | 36.85 |  | 18.7935
 |  |  | Heywood | 1 | 60.74 | 7.57 | 68.31 |  | 86.42 | C |  | 86.42 |  | 3.67285
 |  |  | Ellingham | 10 | 312.4 | 38.96 | 351.36 |  | 368.5 | C |  | 36.85 |  | 15.66125
 |  |  | [NAME] (Great Food Ltd) | 1 | 45.64 | 5.69 | 51.33 |  | 70.7 | A |  | 70.7 |  | 3.00475
 |  |  | Newark | 1 | 53.26 | 6.64 | 59.9 |  | 36.85 | C |  | 36.85 |  | 1.566125
 |  |  | Carlisle | 10 | 220.6 | 27.51 | 248.11 |  | 368.5 | C |  | 36.85 |  | 15.66125
 |  |  | [NAME] | 1 | 84.95 | 10.59 | 95.54 |  | 97.42 | E |  | 97.42 |  | 4.140350000000001
 |  |  | Bristol | 1 | 84.95 | 10.59 | 95.54 |  | 91.14 | D |  | 91.14 |  | 3.87345
 |  |  | Cardiff | 2 | 116.64 | 14.55 | 131.19 |  | 144.2 | C |  | 72.1 |  | 6.1285
 |  |  | [NAME] | 23 | 260 | 32.42 | 292.42 |  | 165
 |  |  | Portadown | 8 | 205.84 | 25.67 | 231.51 |  | 346.08 | C |  | 43.26 |  | 14.7084
 |  |  | Sheffield | 1 | 74.83 | 9.33 | 84.16 |  | 91.14 | D |  | 91.14
 |  |  | Elm | 1 | 45.64 | 5.69 | 51.33 |  | 70.7 | A |  | 70.7 |  | 3.00475
 |  |  | Lough Egish | 26 | 260 | 32.42 | 292.42 |  | 165
 |  |  | Naas (QK Cold Store) | 1 | 68.94 | 8.6 | 77.54 |  | 97.42 | E |  | 97.42 |  | 4.140350000000001
 |  |  | Newport | 1 | 68.94 | 8.6 | 77.54 |  | 97.42 | E |  | 97.42 |  | 4.140350000000001
TOTAL |  |  |  |  | 4191.02 | 522.6 | 4713.62
 |  |  |  |  |  |  |  |  | 5863.450000000001 |  |  |  |  | 224.285675 | 6087.735675000001
 |  |  |  |  | Should come from Delivery List tab, column B
 |  |  |  |  |  |  |  |  |  | Comes from the table on Delivery List tab, [NAME]:T12.
 |  |  |  |  |  |  |  |  |  | It is based on the letter in each row on K (above), and matched with
 |  |  |  |  |  |  |  |  |  | the corresponding letter amount (Band) in K1:T12.
 |  |  |  |  |  |  |  |  |  | Note: anything above 10 is classed as 10.