Function Add-in troubleshooting-Vlookup
I use Vlookup extensively and attempted to add a new function, Vlook.
The function should 1) set the 4th argument to false, and 2) return an empty
string if the regular formula would return an error.
#2 is what I'm having a problem with.
Here's my code
Function vlook(cell,range,column)
vlook = Application.WorksheetFunction.vlookup(cell,range,c olumn,FALSE)
if Application.WorksheetFunction.IsError(vlook) then vlook = ""
End Function
The code works for non-errors, however, returns #VALUE! instead of "" if the
formula cannot be resolved.
Help!
|