formula vs value

[saraua]

I wrote a vlookup formula in a cell and all i get is the formula, not the
value of the formula. How can I get the value to populate?

 

[Gary''s Student]

1. clear the cell
2. format the cell to General
3. re-enter the VLOOKUP formula

 

[joeu2004]

I wrote a vlookup formula in a cell and all i get
is the formula, not the value of the formula.  How
can I get the value to populate?

You get "the formula, not the value" of which cell: the cell with the
vlookup formula, or the cell that vlookup finds?

In either case, go to that cell and be sure that the formula starts
with "=".

 

[Gord Dibben]

A step easier.

Format the cell to General

F2 + ENTER to re-enter the formula.


Gord Dibben MS Excel MVP