
Hi,
I've this formula into several column of a Excel file.
=IF(ISBLANK('Feuil1'!$B$25:$B$113),"",VLOOKUP('Feuil1'!$B$25:$B$113,'Feuil2'!$A$1:$E$65536,2,FALSE))
Into Excel, i read result without problem.
With PHPExcel, i often get result without problem, but sometime i get "#N/A".
I don't understand why, it looks like PHPExcel bug because i don't have any error into MS Excel.
I read something onto office website (sorry, in french only:
http://office.microsoft.com/frfr/excelhelp/corrigeruneerreurnaHP005203936.aspx).
If i sort Excel VLOOKUP target, i get result without error.
Is it a PHPExcel bug, or did i badly use it ?
Thanks for help.


Coordinator
Oct 22, 2013 at 10:23 AM

Please read the section of the developer documentation on locale settings and formulae

