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.