Lookup Postage Price [min & max weight]

I've got a spreadsheet with two worksheets - products & postage - In the products sheet I have a column containing the weight of the item and in the postage sheet I have 3 colums, a from weight, a to weight and the postage cost.

I'm no good with Excel forumlas but can write PHP ones, so I need something like this translated into Excel if possible.

Please Login or Register  to view this content.

So that means show the price in postage sheet column C where the weight in products column H is greater than or equal to the postage weight column A and less than or equal to postage weight column B

Cheers guys [and gals]

Ian

You need to use a SUMPRODUCT function.

My examples assumes Column A assumes lower weight, Column B upper weight and
Column C the price. In cell A12 you type the weight and will then give you
your answer.

=SUMPRODUCT(--(A1:A10<=A12), --(B1:B10>=A12), (C1:C10))

HTH.

"iwgunter" wrote:

>
> I've got a spreadsheet with two worksheets - products & postage - In the
> products sheet I have a column containing the weight of the item and in
> the postage sheet I have 3 colums, a from weight, a to weight and the
> postage cost.
>
> I'm no good with Excel forumlas but can write PHP ones, so I need
> something like this translated into Excel if possible.
>
>
> Code:
> --------------------
> echo postage(C1:C24) WHERE products(H2)=>postage(A1:A24) AND products(H2)<=postage(B1:B24)
> --------------------
>
>
> So that means show the price in postage sheet column C where the weight
> in products column H is greater than or equal to the postage weight
> column A and less than or equal to postage weight column B
>
> Cheers guys [and gals]
>
> Ian
>
>
> --
> iwgunter
> ------------------------------------------------------------------------
> iwgunter's Profile: http://www.excelforum.com/member.php...o&userid=15441
> View this thread: http://www.excelforum.com/showthread...hreadid=509942
>
>