Sumproduct + index formula issue

[jw01]

Hey guys

I am having trouble with some logic in my formula:

=SUMPRODUCT(--(($D7='Data 2015'!$A$14:$A$29)*($Z$11='Data 2015'!$C$13:$S$13)),INDEX('Data 2015'!$C$14:$S$29,,MATCH($Z$10,'Data 2015'!$C$11:$S$11,0)))

Basically, in the above, im trying to get the value from a table by
a) customer name = D10
b) Item type = Z11
c)Category type = D7

I am screwing up as my range for item type "Z11" is look across horizontially in the formula -> any idea how I can change this? I have attached a sample. In my original file, I have many rows and columns in the "Data 2015" tab, so I would like the formula to be dynamic.

Thanks so much!

[zbor]

Here, try this:

Please Login or Register  to view this content.

[jw01]

that works great...thxs man!

[newdoverman]

For your information if needed sometime. This is an array formula. Enter with Ctrl + Shift + Enter

Please Login or Register  to view this content.