My VLOOKUP formula is displaying in the cell instead of the result. The formula is VLOOKUP(A1, income_codes, 2, FALSE) and in the formula editor the result (00017) is calculated correctly.
However the cell displays =VLOOKUP(A1, income_codes, 2, FALSE) instead of the answer 00017.
My view options are not set to display formulas. The codes are formatted as text in the range income_codes as they start with zeros.
Any ideas?
However the cell displays =VLOOKUP(A1, income_codes, 2, FALSE) instead of the answer 00017.
My view options are not set to display formulas. The codes are formatted as text in the range income_codes as they start with zeros.
Any ideas?