VLOOKUP formula displays in cell, will not return data

  • Thread starter Thread starter Chaps
  • Start date Start date
C

Chaps

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.
 
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.
 
Back
Top