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

The second formula will work if your summing using =sum(). That function
ignores text. But if you're using something like:
=b1+C1+D1
Then the summing won't work.



buffgirl71 wrote:

I am using VLOOKUP and when that function doesn't find the value in the
table, it returns "#NA" as the value. I then can't sum the column
because of the #NA in some of the cells. Is there a way that I can
return a zero or a null instead of the #NA? I was thinking that perhaps
the VLOOKUP could be combined with IF... Thanks for your help in
advance.

--

Dave Peterson