- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Repost: Index Match lookup formula returns #N/A error

Subject: | Repost: Index Match lookup formula returns #N/A error |

Posted by: | AC (antcr…@swbell.net) |

Date: | 4 Jan 2007 |

Hello,

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

are numbers.

I have used the following formula to populate file A with the

information from file B:

{=INDEX('[File A.xls]Sheet1'!$D$4:$D$74,MATCH(('[File

B.xls]Sheet1'!A11),'[File A.xls]Sheet1'!$A$4:$A$74,0))}

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

both files.

Any idea why this is happening?

All help is greatly appreciated.

Thank you in advance.

Regards,

A. Crawford

- Re: Repost: Index Match lookup formula returns #N/A error posted by AC on 4 Jan 2007