vlookup repl #/NA with 0

Cathy · Nov 18, 2008

using vlookup i want anytime a #/na is returned to be replaced with 0. I
haven't had any luck with nesting commands to get this acomplished.
thanks

T. Valko · Nov 18, 2008

Try it like this:

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

Sheeloo · Nov 18, 2008

Use

=IF(ISNA(Vlookup(),0,Vlookup()))

replace Vlookup() with your VLOOKUP formula...

Help with If and Vlookup Statement	1	Feb 10, 2009
Help with Vlookup Match and IF statement	2	Feb 10, 2009
How to replae #NA with 0	2	Aug 5, 2007
MONTH function	2	Aug 2, 2009
VLOOKUP	4	Mar 29, 2008
Converting Text	9	Jun 28, 2012
how to convert #na to 0 when using vlookup	3	Oct 2, 2007
Or Function and #NA	2	Jan 13, 2009

Ask a Question