Hello, I know this question has been asked before but I have not been able to solve my problem. I would like to write this formula
"=SI.NON.DISP(RECHERCHEV(CNUM(GAUCHE(G " + i.ToString + ";2));Feuil1!$B$1:$C$104;2;FAUX);"+ Chr(34) +"INDISP"+ Chr(34) + " )"
But it doesn’t work, I have an excel exception.
I tried to replace the semicolons by commas (I read it on a topic) but it doesn’t work.
Knowing that the formula works when I write it manually in Excel.