VLOOKUP returns formula instead of result

[slavvy11]

When I do a VLOOKUP formula, the cell returns the text of the formula instead
of the result. I get the correct result when looking the in Formula Wizard
grey box, but when I get back on the worksheet only the formula is displayed.
This is not a case of Ctrl+~ to look at formulas. Any suggestions???

 

[Gord Dibben]

I would say your cell was pre-formatted as Text.

Format to General then F2 and ENTER.


Gord Dibben MS Excel MVP