VBA Workaround for 255 character limit in cell?

Hello,

I am using VBA to populate a column within my worksheet with the bolded formula below. This returned value in some instances results in "####" displaying in the cell due to total characters in the cell exceeding 255; the cell displays correctly in all other instances when the character count is 255 or less. My code is as follows:

Dim pc As Worksheet
    Set pc = ThisWorkbook.Worksheets("DEV")  
    
    pc.Range("F4").Value = "=IFERROR(VLOOKUP(CONCATENATE($L4,A4),'VAR EXP LOOKUP'!$A$1:$C$799,2,FALSE),"""")"
    pc.Range("F4").Select
    Selection.AutoFill Destination:=Range("F4", Range("F4").End(xlDown))

I have referenced both

HTML Code: 

and

HTML Code: 

but I cannot figure out how to apply this to what I am doing.

Any help will be greatly appreciated. Thanks!

Bjordion