I have this function which works.

=VLOOKUP(A3,NewRev!$A$1:$B$286,2,FALSE) for A3-A500ish

However, if what is in A3 doesn't return a result from the NewRev worksheet,
I get #N/A, my question is, instead of an #N/A result, can I get blank or 0
so that when the result is used in a Sum formula I dont get a #N/A, or do I
have to go through and manually delete anything with #N/A as a result?

TYIA, Brandon