vlookup resulting in #N/A
 

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?

vlookup resulting in #N/A
 

=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?

vlookup resulting in #N/A
 

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

bubbles wrote:

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?

--

Dave Peterson