One way is to amend the if statement:

=IF(ISERROR(MATCH("Lookup Value","column of lookup
array",0)),0,Lookup(...............)

--
steveB

Remove "AYN" from email to respond
"Dean" wrote in message
...
Often I am using lookup functions which may or may not find an exact match
(which is what I want). From these results, typically in a column, I
might want to create a sum or, using two such columns, even a sumproduct
result.

The usual way I deal with this is to write an if statement that says, if
the vlookup result is #N/A, then substitute zero. This yields long
formulas since the lookup function is already pretty long.

I'm wondering if there is a more elegant way to have the sumproduct
compute while ignoring all entries that are #N/A. Perhaps I could do this
with a sumif type function, but I don't know how to do this.

Help, please.

Dean