VLOOKUP formula appears in the cell I need to see the result in

[Guest]

I am using the VLOOKUP function but when I complete the formula, the formula
just appears in the cell I need the result to show up in. Can anyone help?

 

[JulieD]

Hi

it is possible that the cell has been formatted to text prior to the entry
of the formula:
click on the cell, choose format / cells - number tab and click on general
and click ok.
then you might need to press F2 then F9 and enter to get it to work

or

tools / options / view tab, untick formulas

or

ensure that your VLOOKUP formula has no space before the =VLOOKUP(........

 

[Guest]

Many thanks JulieD - your first option was the case. I had thought of that
initially but only checked the column containing the number range I was
searching against and never thought to check the column where I wanted the
result to come in to.
Many thanks.

 

[JulieD]

You're welcome, and thanks for the feedback