Results 1 to 4 of 4

VLOOKUP - Finding postage price vs Weight

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2000
    Posts
    1

    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
    Last edited by Yanni; 10-27-2009 at 01:55 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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