VLOOKUP formula displays in cell, will not return data

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.
 
B

Bob Umlas, Excel MVP

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Problem 1
VLookup 6
Excel Vlookup Help 0
Formula displays in cell 2
Vlookup Formula Help 3
Vlookup Help 3
return a formula instead of a value of a cell 4
Vlookup - return exact phrase 4

Top