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.
Bookmarks