Lookup price and select according to weights

[portcity05]

Hi, I hope someone can help me with a lookup function selecting the correct price according to the items listed weight.
I am not as savvy with Excel as I would like, so I am asking for help on this excercise, what I need to do is select freight pricing from a list according to the weight for each item.
I have a vertical freight list with pricing with price breaks for up to 0.5kg = $6.00, 3kg = $8.00, 5kg = $10.00, 10kg = $12.00, 15kg = $15.00, 20kg = $20.00 etc.
For example i have a particular item @ 8.2kg would need to select the 10kg price because it is greater than 8kg.
Hoping someone has the answer, thanks in advance.
regards Terry

 

[jtakw]

Hi,

You can set it up to look something like this.
This is only accurate to 1 (one) digit after the decimal, as you start with 0.5kg in your OP, but this can be changed to 2 decimal or higher if you require:

Book1
	A	B	C	D	E	F
1		Weight (kg)	Price		Item Weight (kg)	Price
2	0	0.5	6		8.2	12
3	0.6	3	8
4	3.1	5	10
5	5.1	10	12
6	10.1	15	15
7	15.1	20	20
Sheet89

Cell Formulas
Range	Formula
F2	=LOOKUP(E2,$A$2:$A$7,$C$2:$C$7)

 

[portcity05]

Thanks, it worked a treat.
regards Terry

 

[jtakw]

You're welcome.