Forum Discussion
VLOOKUP isn't working for LOTS of data
"When I use the same formulas (modified to include 40,000 rows instead of 10) and add in the real data it returns '#N/A'. Excel gives no error messages."
I'm confused. What is #N/A if not an error message?
#N/A simply states that there is no match for the search criteria. Either the search criteria is not in the search vector or there are little differences which might be difficult to recognize:
l (small L) vs. I (big i) vs. |
Or additional spaces which can be discovered by comparing the length of the text.
That was it!!!!! It wasn't capitalization, but something similar...I was searching with a NUMBER. The fields in the worksheets where designated as 'TEXT'' or 'GENERAL'. Once I reformatted the cells as numbers, it returned values as hoped.
THANK YOU! THANK YOU! You were invaluable.
~Alicia