Vlookup

[Nelson]

I have defined a vlookup, however in the cell instead of the applicable
result/value (text or number) the Vlookup formula is displayed. I'am unable
to figure out what is the problem

I tried by inputting the Summation formula but again the display is the
Formula instead of result.

 

[Rob van Gelder]

You could be in Formula Auditing mode. From the Tools menu, Formula
Auditing, Formula Audting Mode. (or Shortcut key Ctrl+`)

The cell may be formatted as Text instead of, say, General.

 

[Ken]

Or you might highlight the cell/column and then got Edit > Clear > All.
Re-enter the VLOOKUP function. That works for me at times.