Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 "=". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|