VLOOKUP result rounding result in error

We will probably need a sample file in order to see what is happening. When I use a "General" format, functions/formulas will return the full value (including decimals) and will round as needed for the number to fit in the display. So, a result of 89.20000000000000000 will be displayed as 89.2, unless my column is quite narrow, in which case it will display as 89 or ## (indicating that Excel cannot fit the result inside of the narrow column). Using a "General" format, 89 would be displayed as 89.

Using a format of 0.#, will do as you describe -- display 89.2 as 89.2 and 89.0 as 89. (with the decimal point)

In all of these cases, even though Excel rounds the result (either to fit the available column width or as specified by the number format code), the cell retains the value to its full precision. 89.23456789 may display as 89.2, but the cell's value is still 89.23456789.

The only exception I can think for this behavior is when someone (unwisely?) chooses the "precision as displayed" option in Excel's main option dialog.

With the hidden ranges and the hidden sheet, it took me a bit to track down what your spreadsheet is doing, but it looks like it is doing exactly what it is programmed to do. Here's what I see happening:

1) The value for "business licenses" starts out as 89.2 in sheet2 cell F79.
2) There's a lookup function in Sheet2 column M (M5 for business licenses) that pulls values from column F of Sheet2 based on a text string. The lookup function is nested inside of a TEXT() function that converts the number to text in an integer format. So the number 89.2 in F79 becomes the text string "89" in M5. This is where the number gets rounded to the nearest integer as a result of the TEXT() function. Is the TEXT() function in error here?
3) Column AH in deposit form simply copies the values from column M of sheet2. So AH5, like sheet2!M5 is simply "89" (as text not number).
4) The final lookup function in B15 uses the text in the adjacent column and returns the appropriate value from AF:AH. In this case, the result is "89" (still text not number).

The numbers are being rounded to the nearest integer in Sheet2 column M. If this is not what is intended, you will need to look at the TEXT(VLOOKUP(...),"0") formula and see what you intended that formula to do.