Trapping errors in a VLOOKUP function

[Blue Max]

The VLOOKUP( ) function results in an #N/A error if an exact match cannot be
found when the 'range_lookup' value is FALSE. In our case, this error
taints our whole formula. We would rather that the function return the
value zero (0) or FALSE indicating that NO matches were found, without
tainting the whole formula built around the lookup function.

We realize that we can trap the error using the ISERROR () function, but
this enlarges the size of our formula considerably since we already have to
test a rather long formula in order to trap the error. Is there a way to
modify the error value returned by a function for one of its arguments?

 

[Ashish Mathur]

Kinldy post an example and the formula you are using

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com