|Subject:||Repost: Index Match lookup formula returns #N/A error|
|Posted by:||AC (antcr…@swbell.net)|
|Date:||4 Jan 2007|
I have a file A with a list of item numbers in column A and
corresponding quantities in column B. The item numbers in file A were
imported as a text field, the quantity field type is number.
In file B I have the same information, which I typed in by hand.
Therefore, the item number field and the quantity number field types
I have used the following formula to populate file A with the
information from file B:
The curious thing that is happening is that most of the quantity values
are found and filled into file A properly. However, some of the
quantity values are not returned but the formula rather returns the
#N/A value. I checked to make sure that the item numbers are listed in
Any idea why this is happening?
All help is greatly appreciated.
Thank you in advance.