VLOOKUP FUNCTION AND NA

[NA and VLOOKUP]

I am trying to use the VLOOKUP function to display the value of zero if it
does not find a reference lookup. Currently if no reference is found it
display #n/a.

 

[bpeltzer]

=if(isna(your_lookup_function),0,your_lookup_function)

 

[Dave Peterson]

=if(iserror(vlookup(...)),0,vlookup(...))

I am trying to use the VLOOKUP function to display the value of zero if it
does not find a reference lookup. Currently if no reference is found it
display #n/a.