How to Round Up to the Next Value in Excel VLOOKUP

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
VLOOKUP data may be too precise for your needs.

The VLOOKUP function in Microsoft Excel searches an array for a value and returns a corresponding value in a neighboring cell. The function itself doesn't support any sort of manipulation, including rounding, for the data it returns. Excel does, however, offer a separate function for handling this -- the ROUNDUP function. You can embed a VLOOKUP function within a ROUNDUP function, letting VLOOKUP produce a value for the other function to round.

Advertisement

Step 1

Double-click the cell that contains the VLOOKUP function. The cell, may, for instance, contain the formula "=VLOOKUP(C57,C2:D54,2,0)."

Video of the Day

Step 2

Insert the code "ROUNDUP(" into the function, producing, with this example, "=ROUNDUP(VLOOKUP(C57,C2:D54,2,0)."

Advertisement

Step 3

Add a comma to the end of the formula, then the number of decimal places for the rounded result. Then add a closing bracket. For example, if you want to round up to the nearest integer, use the number "0," giving: "=ROUNDUP(VLOOKUP(C57,C2:D54,2,0),0)."

Advertisement

Video of the Day

Advertisement

Advertisement

references & resources