|Deleting #N/A is a waste of time.|
It's quicker not to have them appear in the cell in the first place.
This formula will display "" (blank) if the VLOOKUP returns #N/A or the proper value if the VLOOKUP finds what it is looking for.
=IF(ISNA(VLOOKUP(A1, $B$1:$C$100, 2, 0)), "", VLOOKUP(A1, $B$1:$C$100, 2, 0))
Posting Tip: Before posting Data or VBA Code, read this How-To.