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