vlookup resulting in #N/A

[bubbles]

I understand why I am getting this message I just don't know how to hide that
result on my spreadsheet.
The problem is I have a column of vlookup resulte that I am trying to add
and I can't becuase that results in a #N/A also....help?

 

[Ken Wright]

=IF(ISNA(Your_Formula),"",Your_Formula)

Regards
Ken....................

 

[Dave Peterson]

You could return a 0 or "" (depending on how you're adding the value).

if you're using the + operation (like =A1+C1)
=if(isna(vlookup(...)),0,vlookup(...))

or if you're using =sum() (like(=sum(a:a))
=if(isna(vlookup(...)),0,vlookup(...))