remove #NA from VLookup macro result...?

[blist]

My Lookup value range contains many blank cells I'd like to remain blank. This code works to populate that range as needed, but the blank cells all show a #NA result. How can I edit this (or another?) macro to leave the blank cells empty?

Sub EQL_Lookup()
Dim LastRow As Long
LastRow = Range("A" & Rows.Count).End(xlUp).Row

With WorksheetFunction

     Range("L2:P" & LastRow).Value = .VLookup(Range("L2:P" & LastRow), Sheets(13).Range("A1:C" & LastRow), 2, False)
    
End With
End Sub

 

[blist]

Jeffery Smith, same result as last, Sub or function not defined at the red text

Sub EQL_Lookup()
Dim LastRow As Long
Dim V As Variant
LastRow = Range("A" & Rows.Count).End(xlUp).Row
  With WorksheetFunction
    On Error GoTo NoVal
    Range("L2:P" & LastRow).Value = .VLookup(Range("L2:P" & LastRow), Sheets(13).Range("A1:C" & LastRow), 2, False)
  End With
Exit Sub
: [highlight]NoVal[/highlight]
Range("L2:P" & LastRow).Value = ""
Resume Next
End Sub

 

[Jeffrey Smith]

Change this:

: NoVal

to This:

NoVal: