Could be extraneous spaces in your data.

Or could be that what looks like numbers are actually text.

If a number is text, simply re-formatting will not change it to a number.

Provide a sample of your data and what throws the errors.


Gord Dibben MS Excel MVP

On Wed, 19 Aug 2009 16:05:01 -0700, lhp
wrote:

An error message of "#N/A" is returned as the product of my vlookup formula
which references data in a worksheet that has been exported from an
accounting application into MS Excel. However, when the same item that is
being looked up is typed in then the desired result appears.

The export data is originally created in a version of MS Excel different
from that which I am using but I then save it into an Excel 97_2003 Workbook.
I am using Excel 2007. The formatting of the original data and that typed
in are the same.

Any thoughts?


Thanx,
lhp