Trapping errors in a VLOOKUP function

B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With VLOOKUP 2
Word macro that can call cells out of Excel for a find and replace 0
Use TODAY() function as the criteria in a SUMIF formula 1
VLOOKUP & Data Validation 0
vlookup formatting problem 1
Adding a VLookup to an AutoComplete ComboBox 0
ISERROR on VLOOKUP 3
Vlookup to reference offset 1

Top