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

"Nelson" wrote:

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.