how to convert #na to 0 when using vlookup

Guest · Oct 2, 2007

When I use Vlookup, #NA returned if the vulue is not found. I need help to
convert #NA to zero or blank. Please help and thanks!

Peo Sjoblom · Oct 2, 2007

=IF(ISNA(vlookup),"",vlookup)

replace vlookup with your formula

--

Regards,

Peo Sjoblom

Guest · Oct 2, 2007

try =if(isna(your_vlookup),0,your_vlookup)

georgeami · Feb 17, 2013

much easyer "=IFERROR(VLOOKUP,0) Replace "Vlookup" with your formula and it will return 0 instead #N/A.

Converting Text	9	Jun 28, 2012
vlookup repl #/NA with 0	2	Nov 18, 2008
MONTH function	2	Aug 2, 2009
VLOOKUP	4	Mar 29, 2008
How to convert VLOOPUP error value #NA to 0?	4	Feb 25, 2006
Help with If and Vlookup Statement	1	Feb 10, 2009
Help with Vlookup Match and IF statement	2	Feb 10, 2009
Vlookup result change	1	Mar 6, 2007

Ask a Question