Vlookup and returning #n/a

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way to return a zero or blank in the place of #n/a in a vlookup
result that is FALSE?
 
=IF(ISNA(vlookup_formula),0,vlookup_formula)

--

HTH

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

=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
or
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
(instead "" you can use 0 as return value for error too)
 
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...
 
You must log in or register to reply here.

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

Vlookups to return a N/A value 3
Eliminate #N/A in Vlookup formulas 2
Vlookup and If statement help 1
Vlook up value is #N/A 4
Errors encountered when using If & Vlookup formulas 2
Help With VLOOKUP 2
VLOOKUP 3
VLOOKUP using FALSE returning blanks and #N/A 1

Back
Top