Multiple Row and Column Lookup

[itty]

Dear All,
I want to segregate a report year wise. My data is 3 years together and I want to segregate yearly based on 4 values. One criteria in Row and other 3 criteria in Columns. Sample sheet is attached herewith.
Thanks in advance.

[JohnTopley]

In C9 and copy across and down

=SUMPRODUCT(('Master data'!$A$8:$A$16=$A9)*('Master data'!$I$3:$AR$3=C$4)*('Master data'!$I$6:$AR$6=C$7)*('Master data'!$I$5:$AR$5=C$6)*('Master data'!$I$8:$AR$16))

I would suggest you change "Current Year" / "Previous Year" to numeric years (2016/2015)

If you made the dates ["Sales Year") in the form 01/01/2016 (format as "mmm-yy") you remove the need for the "Month" row.

[itty]

Dear John,
Thanks for your help. Working fine.