ExcelBanter - formula vs value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula vs value (https://www.excelbanter.com/excel-discussion-misc-queries/216530-formula-vs-value.html)

saraua

formula vs value

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

formula vs value

1. clear the cell
2. format the cell to General
3. re-enter the VLOOKUP formula
--
Gary''s Student - gsnu200826

"saraua" wrote:

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?

joeu2004

formula vs value

On Jan 14, 3:29*pm, saraua wrote:
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

formula vs value

A step easier.

Format the cell to General

F2 + ENTER to re-enter the formula.

Gord Dibben MS Excel MVP

On Wed, 14 Jan 2009 15:39:01 -0800, Gary''s Student
wrote:

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

All times are GMT +1. The time now is 04:26 AM.