Lookup Postage Price [min & max weight]
- From: iwgunter <iwgunter.22wn1b_1139392202.3649@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2006 03:48:44 -0600
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?action=getinfo&userid=15441
View this thread: http://www.excelforum.com/showthread.php?threadid=509942
.
- Prev by Date: Re: How to 'freeze' the output generated by RAND()?
- Next by Date: Re: Formula = Today's date + 1 month
- Previous by thread: How to 'freeze' the output generated by RAND()?
- Next by thread: Adding values for selected years
- Index(es):
Relevant Pages
|
