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

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

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