Vlookup #N/A using VBA

[green99]

Is there any way that I can get #N/A using vlookup code in VBA if the corresponding value is not available?
It just gives errors when the value is not found.

On using On Error Resume Next , the error is resolved however, still after trying many ways I am unable to print #N/A.
Kindly help

[Aflatoon]

Cross-posted and already answered here: https://www.excelforum.com/excel-programming-vba-macros/1207624-vlookup-n-a-using-vba.html