Prev: Pivot Table
Next: Number format
From: Chaps on 12 May 2010 14:39
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.
From: Bob Umlas, Excel MVP on 12 May 2010 14:50
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.
 | 
Pages: 1
Prev: Pivot Table
Next: Number format