Sub test()
'
' test Macro
'
Dim I As Long
With Sheets("BOM")
.Activate
For I = 72 To 12000
If .Cells(I, 1) <> "" Then
.Cells(I, 12).FormulaR1C1 = "=IF(RC[-11]=""ITEM"",""Unit price"",VLOOKUP(RC[-3],[Electrical_codebook_SES.xlsx]Codebook!C1:C6,6,FALSE))"
.Cells(I, 13).FormulaR1C1 = "Formule A définir"
End If
Next I
End With
End Sub