Index Match from data sheet

[Matthewious2016]

I have tried this

Please Login or Register  to view this content.

like a charm on table 1.

Table 2
But what if the first Column of table change to something else? And I want sum up if the code found out this keyword called "IPhone6S" and so on.

[:) Sixthsense :)]

	E
6	=SUMIFS(INDEX(Plan!D:G,,MATCH("*"&$E$4&"*",Plan!$D$4:$G$4,0)),Plan!B:B,C6,Plan!C:C,D6)

	J
6	=SUMIFS(INDEX(Plan!D:G,,MATCH("*"&$J$4&"*",Plan!$D$4:$G$4,0)),Plan!C:C,I6)

Drag both the formula's down

[Matthewious2016]

I have tried on this test file already. But what if on plan sheet "IPhone6S" (with green colour) is another type of stuffs. Then I only want to select certain area to sum, is it possible?

So green coloured "IPhone6S" are one whole bunch of "Phone", sum it together. Orange coloured "IPhone6S" is from "QWE".
I have uploaded a latest file for you.

[:) Sixthsense :)]

You can't expect your desired result if you don't keep the data in a structured way...

[Matthewious2016]

I just test formula its working you posted on this thread. It's the way I want but it's okay man