ROUND function with VLOOKUP

[jablo1312]

I'm using Vlookup to transfer a large number of cells from one sheet to another and want to limit the decimal points on the tranferred cells. Currently each number fills as many decimals places as possible- how can I incorporate the ROUND function into a VLookup formlua? Thanks.

[NBVC]

You can format the result cells to show only a certain number of decimals... would that work for you?

Select the results range, right-click and select Format Cells, then from Number tab, select Number and choose decimal places.