I have the follow code to set cell AF8 to a blank cell

Sheets("Main Sheet").Range("AF8").Value = ""

Is it possible to have the following code write to cell AF8

"=LOOKUP(2,1/(DATA!L1:L20212<>""),DATA!L1:L20212)"

so the full code will read

Sheets("Main Sheet").Range("AF8").Value = "=LOOKUP(2,1/(DATA!L1:L20212<>""),DATA!L1:L20212)"

Many thanks