Forumla to Find Shipping Cost from Weight

[daleyelland]

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.

Item Weight Min <tbody> </tbody>	Item Weight Max <tbody> </tbody>	Cost <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

 

[VBA Geek]

Perhaps you look for this?

Excel 2010
	A	B	C	D	E	F	G
1	Item Weight Min	Item Weight Max	Cost
2	0	150	1.66			Weight:	100
3	151	400	1.72			Cost:	1.66
4	401	900	1.77
5	901	1400	2.19
Sheet4

Cell Formulas
Range	Formula
G3	=LOOKUP(G2,A2:A5,C2:C5)

 

[daleyelland]

Thank you so much!