+ Reply to Thread
Results 1 to 5 of 5

Postage cost against item value and weight

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Aberdeen
    MS-Off Ver
    2013
    Posts
    3

    Postage cost against item value and weight

    Please see attached spreadsheet.

    I have generated a spreadsheet which uses 'Index' and 'Match' to come up with the cost of postage if the item being posted is of a certain value and of a certain weight.

    I have another spreadsheet which calculates a value of an item before posting - how do I get the attached spreadsheet to calculate the postage if A8 = £49.95 and fell into the weight category 2 - 5kg.

    I have tried using 'Sumproduct' for the value, but I don't know how to integrate it all together.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Postage cost against item value and weight

    Hi

    an attempt without data validation in A8:

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Hope it helps
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    10-16-2014
    Location
    Aberdeen
    MS-Off Ver
    2013
    Posts
    3

    Re: Postage cost against item value and weight

    please see revised spreadsheet...

    What if A8 = £49.95

    How could a formula be written so £49.95 is used as the value.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-16-2014
    Location
    Aberdeen
    MS-Off Ver
    2013
    Posts
    3

    Re: Postage cost against item value and weight

    all sorted now... used INDEX, MATCH and MATCH
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Postage cost against item value and weight

    Hi,

    great: thanks for sharing feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating total cost from range of cell tally's by cost of item.
    By patrickdjames in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 11-04-2012, 10:27 AM
  2. [SOLVED] calculating postage costs based on weight but only if postage is required.
    By waitey1234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2012, 03:28 PM
  3. Searching for orders with more than one item and postage price combined
    By hudwink in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2011, 05:23 AM
  4. VLOOKUP - Finding postage price vs Weight
    By Yanni in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-05-2010, 04:27 PM
  5. Lookup Postage Price [min & max weight]
    By iwgunter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2006, 07:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1