ExcelBanter - VLOOKUP formula displays in cell, will not return data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP formula displays in cell, will not return data (https://www.excelbanter.com/excel-discussion-misc-queries/263632-vlookup-formula-displays-cell-will-not-return-data.html)

Chaps

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.

Bob Umlas, Excel MVP

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.

bala_vb

Quote:

Originally Posted by Chaps (Post 953130)

Is the lookup_value exist in the table array?
Can you copy sample formula or spreadsheet with attachment. We will try to replicate and let you know the solution

All times are GMT +1. The time now is 05:52 AM.