I am working with Vlookup and I will attempt to explain the error I am getting. I am working with two datasheets.
I have a list of about 687 records in data sheet 1 and about 385 records in datasheet 2. I am using the same a unique Id in both data sheet to match records. When I perform the vlookup in datasheet 1 against datasheet 2, and copy it down the column, it returns a value for the first few records , but only to the point in which a record is found. Instead of returning a #NA value only for the record that is not found, it returns a value of #NA for the rest of the records, of which I know there are other matching unique ID’s in datasheet 2. If I remove the record that is not found, and copy the formula again, it will again return values, but only to the next records that is not found… I hope I am explaining the error properly. The unique ID columns are formatted the same.
I am befuddled. Can you help?
Thanks…
Bookmarks