Sub Macro2()
Dim Fin As Long
Fin = [A65536].End(xlUp).Row
Range("B9").FormulaR1C1 = _
"=IF(AND(R3C5=1),IF(RC1<>"""",(R[-2]C+1)),"""")"
With Range("B10:B" & Fin)
.FormulaR1C1 = _
"=IF(AND(R3C5=1),IF(RC1<>"""",(R[-1]C+1)),"""")"
End With
With Range("D9:D" & Fin)
.FormulaR1C1 = _
"=IF(OR(R3C5=1),VLOOKUP(RC1,Base!C1:C45,3,),"""")"
End With
With Range("E9:E" & Fin)
.FormulaR1C1 = _
"=IF(OR(R3C5=1),VLOOKUP(RC1,Base!C1:C45,4,),"""")"
End With
With Range("F9:F" & Fin)
.FormulaR1C1 = _
"=IF(OR(R3C5=1),VLOOKUP(RC1,Base!C1:C45,9,),"""")"
End With
End Sub