SUMPRODUCT*OFFSET with Multiple Ifs??

Please reference the attached file.

In column C, I need a formula that locates the correct data from the Historical tab. It first needs to match Company ID, Year, Period, and then the correct categories (ie RR Sales, MS Costs, and so on).

Do I use a SUMPRODUCT*OFFSET with multiple Match inserts? If so, how do I put that together?

*Prior year should just be Current Year minus 1 (B1(2014)-1=2013). I'm sure you could have figured that out though.

Thanks!