I have the following code

lastRow = Range("A" & Rows.Count).End(xlUp).Row
Range("D2:D" & lastRow).Value = "=IF(BF2<>"""",VLOOKUP(RC[54],'[" & PMMBRList.Name & "]Sheet1'!C1:C3,3,0),VLOOKUP(RC[-1],'[" & PMMBRList.Name & "]Sheet1'!C2:C3,2,0))"
This works, apart from the fact that it gives me the following result:

=IF('BF492' <>"",VLOOKUP(BF492,'[Owners.xlsx]Sheet1'!$A:$C,3,0),VLOOKUP(C492,'[Owners.xlsx]Sheet1'!$B:$C,2,0))
I can't for the life of me figure out how to get the ACTUAL cell after the beginning of the IF statement, (BF492) instead of ('BF492')

How do I remove the ' ' that surround the cell?