I know that putting a "False" at the end of a VLookup will return a "#NA" when it can't find a match, but is there a way for it to return a zero("0") instead? I have been fooling with IF(VLookup( for a while to no avail.

OR, is there a way to SUM a group of numbers where "#NA" may be one of those numbers.

Either would solve my problem.

Cheers!