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

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

"bubbles" wrote in message
...
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?