VLOOKUP - Finding postage price vs Weight

I'd like to calculate automatically the postage price of a parcel according to a weight table but there is a problem with vlookup.

A B

1 100g £1.83
2 250g £2.16
3 500g £2.60
4 750g £2.99
4 1000g £3.45

Now if I use vlookup on this occasion for a 150g parcel, the price that will be returned is £1.83 as vlookup will return the nearest lower value to the 150g which is 100g. However, the postage for an 150g parcel is £2.16 instead as from 101g-250g the price is £2.16 according to the table.


Is there a way of doing this other than a series of "IF" functions.
If VLOOKUP could return the cell instead of the value of the cell perhaps I could add one cell down and find the value this way but I don't know how to do that.

Any suggestions please ?

Thanks
Yanni

Try

=INDEX(B1:B5,MATCH(TRUE,INDEX(A1:A5>=D1,0),0))

where values in Column A are actually numbers...

and D1 contains weight to lookup

=LOOKUP(150,A1:A6,B2:B7) will return the correct answer

To handle weights less than 100, add a row on top and fill the two new cells with 0's.