I would like create a table where i can just input the weight and zone of the product and see it is cost.
I have weight ranges like; first two cloums are weight range and next 3 are the prices based on the zones.
<tbody>
</tbody>
So i need the formula to check where the written weight in first two colums and check correct zone and bring up the right cost for that.
Can you help me on this one?
I have weight ranges like; first two cloums are weight range and next 3 are the prices based on the zones.
<tbody> </tbody> |
<tbody>
</tbody>
So i need the formula to check where the written weight in first two colums and check correct zone and bring up the right cost for that.
Can you help me on this one?