Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim Fx As String
- Dim Gx As String
- ActiveCell.FormulaArray = "=INDEX(B.xlsx!Tabla1[Time],MATCH(1,(B.xlsx!Tabla1[Operation]=$R$1)*(B.xlsx!Tabla1[C1]=""MATERIAL A"")*(B.xlsx!Tabla1[C2]=""" & Fx & """)*(B.xlsx!Tabla1[C3]=""" & Gx & """),0))"
- ActiveCell.FormulaArray = "=INDEX(B.xlsx!Tabla1[Time],MATCH(1,(B.xlsx!Tabla1[Operation]=$R$1)*(B.xlsx!Tabla1[C1]=""MATERIAL A"")*(B.xlsx!Tabla1[C2]=""" & Fx & """)*(B.xlsx!Tabla1[C3]=""" & Gx & """)*(B.xlsx!Tabla1[C4]="">8ml""),0))"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement