Index match within sumproduct
 

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(C 17:C24,zz_margin_factors_desc,0)))*(E17:E24<""))

Thanks for all help offered!
Regards,
Bony

Index match within Sumproduct
 

Hi Bony

Possibly the range
zz_margin_profile_percs
is not of the same dimensions as C17:C24
--
Regards
Roger Govier

"Bony Pony" wrote in message
...
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(C 17:C24,zz_margin_factors_desc,0)))*(E17:E24<""))

Thanks for all help offered!
Regards,
Bony

Index match within Sumproduct
 

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

"Roger Govier" wrote:

Hi Bony

Possibly the range
zz_margin_profile_percs
is not of the same dimensions as C17:C24
--
Regards
Roger Govier

"Bony Pony" wrote in message
...
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(C 17:C24,zz_margin_factors_desc,0)))*(E17:E24<""))

Thanks for all help offered!
Regards,
Bony