How to coad iferror along with vlookup function in VBA

[Arif_Tamboli]

Hi
I am able to coad vlookup in VBA, however iam not able to multi function (iferror+vlookup) in VBA Coad.

 

[offthelip]

simple answer don't use Vlookup in VBa, there is a much faster more flexible way of doing the same thing in VBa, and you can trap the error yourself, see this link:
https://www.mrexcel.com/forum/excel-questions/1043185-vlookup-vba-alternative.html