I can't see the problem with this formula but I get the following error message.
Method range of object global failed


Range("AW3:AW" & SecondLastRow - 1) = "=VLOOKUP(AT3,Range(""J3:J"" & LastRow - 1),8,FALSE)"
Thanks in advance