Results 1 to 2 of 2

How to round up to closest match in vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2008
    Location
    Atlanta
    Posts
    65

    How to round up to closest match in vlookup

    I have a list of weights for various widgets that I ship. The shipping price chart and the actual widget weights are never the exact same on the weights. I need the values pulled by the vlookup to bring in the next highest value not the one that is the closest to it.

    ex: widget weights .48 lbs

    price chart:has options for pricing on .43lbs and .50 lbs.

    I need it to pull from the .50 data but my regular vlookup is pulling from .43. I have included an example spreadsheet.
    Attached Files Attached Files
    Last edited by Onestopfanshop; 01-04-2011 at 05:28 PM.

Thread Information

Users Browsing this Thread

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

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