Index match within sumproduct

B

Bony Pony

Hi all,
I'm sure there's a simple answer to this.

Why does the Match work in this:
=SUMPRODUCT((MATCH(C17:C24,zz_margin_factors_desc,0)))*(E17:E24<>""))

but in this example, the match returns a #Value
=SUMPRODUCT((INDEX(zz_margin_profile_percs,MATCH(C17:C24,zz_margin_factors_desc,0)))*(E17:E24<>""))

Thanks for all help offered!
Regards,
Bony
 
R

Roger Govier

Hi Bony

Possibly the range
zz_margin_profile_percs
is not of the same dimensions as C17:C24
 
B

Bony Pony

Hi Roger,
Thanks for the reply. However, in the first example, sumproduct steps
through the match lookup range of C17:C24. This is what I would expect it to
do.

In the second example, the lookup range throws a #Value.

I expect it is the INDEX and SUBPRODUCT that clash. Anyway, I found a
workaround.

Best regards,
Bony
 
Top