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