Vlookup does find value returns blank no errors

asked 2015-08-11 16:54:28 +0100

ymail99 gravatar image

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?

edit retag flag offensive close merge delete