Cubic | Local $ | Outer Area $ | ShortHaul $ | Longhaul $ | InterIsland $ |
0.003 | 2.00 | 4.00 | 6.00 | 8.00 | 10.00 |
0.005 | 2.20 | 4.40 | 6.60 | 8.80 | 11.00 |
0.008 | 2.40 | 4.80 | 7.20 | 9.60 | 12.00 |
0.01 | 2.60 | 5.20 | 7.80 | 10.40 | 13.00 |
0.012 | 2.80 | 5.60 | 8.40 | 11.20 | 14.00 |
0.016 | 3.00 | 6.00 | 9.00 | 12.00 | 15.00 |
0.02 | 3.20 | 6.40 | 9.60 | 12.80 | 16.00 |
<tbody>
</tbody>
Hi, I am new here and have spent a bit of time looking for the best way to obtain the right answer.
The above table is charges our courier applies for tickets to different areas we send orders.
I already have another worksheet with a cell that is determining the correct area (IE. local, etc) but also need to enter into the next cell a number up to 3 decimal places. From there I need to get a result of the higher value. IE. 0.006 local = $2.40 charge OR 0.011 longhaul = $11.20
I have tried index/match but it needs an exact match. I have tried vlookup with TRUE but it rounds down. I have tried roundup on the cell figure first and then vlookup but the increments in the courier rate schedule don't match.
Does anyone have any ideas of what formula I can use? I'm going crazy