Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Vlookup does find value returns blank no errors

I am using vlookup to get values from a cvs file. The cvs file is an array of 7 columns and 40 rows. This works fine =VLOOKUP(A3,'file:///home/me/udv.csv'#$Sheet1.$A$1:$G$100,X,0) where the capital x (the index) in the formula is 2,3,4. It does not work for capital x (the index) for 5,6,7. The return for 5,6,7 is blank. There are no errors, NA, etc. What am I doing wrong?