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