IsError(WorksheetFunction.....)

[mikeymay]

Is it possible to use the an IsError function with the following?

Application.WorksheetFunction.VLookup(intBranchCode, rngPLanLookup, 6, False)

Thanks

 

[Sektor]

Did you try it yourself?

 

[RoryA]

No, because it will return a runtime error if the lookup value is not found. What you can do is use a Variant and Application.Vlookup instead:

Dim varValue
varValue = Application.VLookup(intBranchCode, rngPLanLookup, 6, False)
If IsError(varValue) Then
' do whatever
End If