VLOOKUP returns formula instead of result

S

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???
 
G

Gord Dibben

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

Format to General then F2 and ENTER.


Gord Dibben MS Excel MVP
 
Top