Combining Lookup and ROUNDUP function

[nathanexcelhelp]

Just wondering if its possible to round up a figure returned from a VLOOKUP?

Here is my current formula which returns a financial amount...

=IFERROR(VLOOKUP($B5,'010115 - 311215'!$A$2:$R$2542,12,FALSE), "")

I thought I might be able to do the following, but it doesn't seem to work...

=IFERROR(VLOOKUP($B5,'010115 - 311215'!$A$2:$R$2542,12,FALSE), "", ROUNDUP)

[JohnTopley]

try

=IFERROR(ROUNDUP(VLOOKUP($B5,'010115 - 311215'!$A$2:$R$2542,12,FALSE),0), "")

[nathanexcelhelp]

try

=IFERROR(ROUNDUP(VLOOKUP($B5,'010115 - 311215'!$A$2:$R$2542,12,FALSE),0), "")

Perfect. Thank you!

Just for future reference could you explain what the ,0) represents after FALSE?

[JohnTopley]

0 is a parameter of ROUNDUP and is the number of digits to which you want to round.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[nathanexcelhelp]

Thank you that's great.

RESOLVED