Hi,
I am using this formula to match values in H with others in L, to extract corresponding values in M

{=OFFSET($M$5;MATCH($H$7:$H$12;$L$6:$L$8;0);0;1;1)}

Capture.PNG

This works fine and the array formula evaluates like this
{10;20;30;10;20;30}

Now I would like to use this formula inside sumproduct,

like this:

{=SUMPRODUCT(OFFSET($M$5;MATCH($H$7:$H$12;$L$6:$L$8;0);0;1;1);$I$7:$I$12)}

But it evaluates as 0??

I hoped it would do the sumproduct of {1;2;3;4;5;6} and {10;20;30;10;20;30}