| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP formula displays in cell, will not return data
I had an older version of Excel (97 maybe?) and our office updated to 2007.
Now my vlookup will not return data. The vlookup formula appears in the cell or I get the NA#. I've formatted my lookup cells and table to General but still get the same result. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP formula displays in cell, will not return data
After formatting the cell as General, re-enter it (F2/Enter) - if you're
still seeing the formula, press Ctrl/~ -- you're looking at the formula layer instead of the value layer. "Chaps" wrote: I had an older version of Excel (97 maybe?) and our office updated to 2007. Now my vlookup will not return data. The vlookup formula appears in the cell or I get the NA#. I've formatted my lookup cells and table to General but still get the same result. |
|
#3
|
|||
|
|||
|
Quote:
Can you copy sample formula or spreadsheet with attachment. We will try to replicate and let you know the solution
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referenced cell displays formula, not data | New Users to Excel | |||
| VLOOKUP displays formula rather than result Excel 2007 | Excel Worksheet Functions | |||
| The VLookup function displays the formula in the cell, not data. | Excel Worksheet Functions | |||
| vlookup formula fails to return data search item is text | Excel Worksheet Functions | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
