daleyelland
New Member
- Joined
- Jan 18, 2018
- Messages
- 2
Hi all,
Having a thick moment here and can't get my head round something that I'm sure is really simple. In Sheet1, I have a table of items and the weight of the item is in column X.
In Sheet2 I have a table of shipping costs depending on weight. The table is below.
<tbody>
</tbody>
Say for example an item weighs 100 it would cost 1.66, 500 would cost 1.77 etc. I need a formula that assigns a group for each weight, eg. 100 = 0-150, and then gives the cost at the end
Many thanks
Having a thick moment here and can't get my head round something that I'm sure is really simple. In Sheet1, I have a table of items and the weight of the item is in column X.
In Sheet2 I have a table of shipping costs depending on weight. The table is below.
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
0 | 150 | 1.66 | |||
151 | 400 | 1.72 | |||
401 | 900 | 1.77 | |||
901 | 1400 | 2.19 |
<tbody>
</tbody>
Say for example an item weighs 100 it would cost 1.66, 500 would cost 1.77 etc. I need a formula that assigns a group for each weight, eg. 100 = 0-150, and then gives the cost at the end
Many thanks