S saraua Jan 14, 2009 #1 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?
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?
G Gary''s Student Jan 14, 2009 #2 1. clear the cell 2. format the cell to General 3. re-enter the VLOOKUP formula
J joeu2004 Jan 14, 2009 #3 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? Click to expand... 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 "=".
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? Click to expand... 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 "=".
G Gord Dibben Jan 15, 2009 #4 A step easier. Format the cell to General F2 + ENTER to re-enter the formula. Gord Dibben MS Excel MVP
A step easier. Format the cell to General F2 + ENTER to re-enter the formula. Gord Dibben MS Excel MVP
