Hello all
I am trying to complete a Vlookup in column "AB" but only on the active line that you enter into
This is what I have tried
[Contact = Range("AB" & ActiveCell.Row).FormulaR1C1 = "=VLOOKUP(RC[-14],'Site Names'!C[-26]:C[-25],2,FALSE)"]
Any ideas please to correct this so that it works