vlookup repl #/NA with 0

[Cathy]

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]

Try it like this:

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

 

[Sheeloo]

Use

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

replace Vlookup() with your VLOOKUP formula...