Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup data difficulty
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup data difficulty
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup data difficulty
If you are dealing with text values, then you might have unwanted
spaces (or more-likely non-breaking spaces) at the end of the data you have imported. If you are looking up numbers then it might be that they are numbers in the lookup table but text values in the sought-item cell, or vice versa. Check for extra characters by using =LEN(cell) in a helper cell - does this give the number of characters tha you expect? Check for text values using =ISTEXT(cell) (which will return TRUE if the cell contains text). Check for numbers using =ISNUMBER(cell), and so on ... Hope this helps. Pete On Aug 20, 12:05*am, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Difficulty | Excel Worksheet Functions | |||
Function Difficulty | Excel Discussion (Misc queries) | |||
VLOOKUP difficulty sorting data? | Excel Worksheet Functions | |||
Difficulty in transposing | New Users to Excel | |||
VLOOKUP Difficulty | Excel Discussion (Misc queries) |