vlookup resulting in #N/A

B

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to correct a #N/A in vlookup 1
VLOOKUP returning #N/A ?? 3
VLOOKUP returning #N/A result 2
#N/A 5
Hiding VLookup #N/A 1
Remove #n/a in vlookup to sum results 6
Getting This Unknown Error From Outlook! 1
#N/A 4

Top