Vlookup on active line

[VbaHell]

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

 

[alansidman]

Re: vlookup only in a cell when the row is selected

but it's not correct

Please explain what this means.

Are you getting a compile error message? Unexpected results?