Vlookup and returning #n/a

C

Cathrine

is there a way to return a zero or blank in the place of #n/a in a vlookup
result that is FALSE?
 
B

Bob Phillips

=IF(ISNA(vlookup_formula),0,vlookup_formula)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Arvi Laanemets

Hi

=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
or
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
(instead "" you can use 0 as return value for error too)
 
C

Cathrine

Thank you both!!

Arvi Laanemets said:
Hi

=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
or
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
(instead "" you can use 0 as return value for error too)
Click to expand...
 

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

Same forumula returns both 0 & N/A 2
Help With VLOOKUP 2
Multiple VLOOKUP in an IF statement 2
Vlookups to return a N/A value 3
Use & with two formulas 2
Eliminate #N/A in Vlookup formulas 2
Can I add a formula or function to Vlookup? 1
Vlook up value is #N/A 4

Top