Vlookup question

D

Dennis

I'm trying to get my VLookup to return the value 0 if it
does not find the appropriate number. (As opposed to #n/a)

Any ideas?
 
C

Chip Pearson

Dennis,

You have to write the formula in the form

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

The disadvantage of this approach is that in many (most?) cases
the VLOOKUP operation will be done twice.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
 
G

George King

This makes for a long formula, but:

=IF(ISERROR(lookup_formula),0,lookup_formula)

If there is an error (like #N/A), this will return a
zero, otherwise it will execute the lookup formula.
 
Top