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...