Bad formula result

Topics: Developer Forum
Oct 18, 2013 at 9:27 AM
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/fr-fr/excel-help/corriger-une-erreur-n-a-HP005203936.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