Hi,

I have to look up a value from a array suing sumproduct() function. This array consists of Financials data.

As unlike vlookup or index match, sumproduct() doesn't return NA error, I get zero returns for those data items that are not part of the look up array which is not correct as per financial reporting.

How to over come this? The key is I should use only sumproduct function...

Can some one help?