Range("F20:F60").Formula = _
"=IF(RC[-3]="""","""",VLOOKUP(RC[-3],'Commandes Clients'!R10C1:R1000C4,4,0))"
"=If(C20="""","""",vlookup(C20,'Commandes Clients'!$A$10:$D$1000;4;0))"
[O26].Formula = "=IF(N26=""c"",""oui"","""")"
Bonjour à tous,
Peux-tu essayer :
VB:Range("F20:F60").Formula = _ "=IF(RC[-3]="""","""",VLOOKUP(RC[-3],'Commandes Clients'!R10C1:R1000C4,4,0))"
A+ à tous
Range("F20:F60").FormulaLocal = _
"=SI(C20="""";"""";RECHERCHEV(C20;'Commandes Clients'!$A$10:$D$1000;4;0))"