How to perform SI.ND (VLOOKUP () ...) in PHPExcel

Navigation
0

Good I would like to know if it is possible to make this formula in PHPExcel 

=SI.ND(BUSCARV(A46;Dat_STATUS_EXP;2;FALSO);0)+Q46

I have noticed that the function SI.ND could not use it, since it does not exist for excel 2007.

I have tried to do something like that, but it does not work for me. 

setCellValue('P'.$i,'=IFERROR(VLOOKUP(A'.$i.'Dat_STATUS_EXP;2;FALSO);0)+Q'.$i)

Let's see if anyone can come up with any form, either with another formula if necessary, but with the same result.

    
asked by TaGy 29.09.2017 в 15:25
source

1 answer

0

Solved, it was a mistake of the;

Here I leave the syntax, in case someone serves you 

setCellValue('P'.$i,'=IFERROR(VLOOKUP(A'.$i.',Dat_STATUS_EXP,2,FALSE),0)+Q'.$i);

Greetings!

    
answered by 29.09.2017 / 20:34
source
How to verify server response? Avoid copies of an app