I have used Excel for some years, but now I am in front of something I can't manage,
I have a plain database, and I look up there some info with the VLOOKUP. I get for some references the desired info, but for some others I reveive #N/A.
Obviously, I confirmed that the info is there indeed, and in the same format, and copied data between lines, and still I get the damned #N/A.
I couldnt find anything different between a line that works and one that not works.
I isolated the non working formulas and I can't find nothing wrong.
I am even more frustrated because among my friends and workmates I am the "Excel guy", and I this problem is becoming a sort of personal challenge.
If you are willing to give me a hand I can send you my XLS file, which has no macros and no references to other files. Anyway it is here available in a ZIP file.