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 (e-mail address removed)
 
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.
 

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
Same forumula returns both 0 & N/A 2
trouble with (complicated) vlookup searching another workbook 2
Use & with two formulas 2
Vlookup 1
Multiple VLOOKUP in an IF statement 2
Searching the formula (not the value) for a text string 1
VLOOKUP & Data Validation 0

Top