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.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Nelson" wrote in message
...
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.