If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|