I have two questions:
I'm summarizing data into specific groups and individuals to create charts from a Pivot that has duplicate month column headings and then second column heading labels. For example:
Columns C & D row 6 both have January 2016 as a heading
Column C row 7 has heading Work Order and column D row 7 has heading Calls

Columns A & B, Group and Agent have unique fields I want to either lookup or sum based on match with corresponding column labels

Q1: I've been able to create lookup functions for either two row matches or two column matches but cannot get two row and two column matches to work. Is that possible?
Formula to match both column headings:
=IFERROR(INDEX(Data!$A$5:$BA$1550,MATCH('WO Summary'!$AD2,Data!$A$5:$A$1550,0),MATCH('WO Summary'!AG$1&'WO Summary'!$AC2,INDEX(Data!$6:$6&Data!$7:$7,0),0)),0)
if I expand the match function for rows it does not work
=IFERROR(INDEX(Data!$A$5:$BA$1550,MATCH('WO Summary'!$AD2&'WO Summary'!$AE2,Data!$A$5:$A$1550&Data!$B$5:$b$1550,0),MATCH('WO Summary'!AG$1&'WO Summary'!$AC2,INDEX(Data!$6:$6&Data!$7:$7,0),0)),0)
If I use the row match I have to hard code the column

Q2: I'm using the SUMIFS function to sum data of a specific group but have to manually change for each month since the column for let's say Work Orders (which is a row in the summary tab) is every other column in the pivot. Is there a function that can be used to match the column headings, set the row values to insert for the sum_range value?
Formula for summing, =SUMIFS(Data!C5:C1550,Data!$A$5:$A$1550,"*TCC*",Data!$B$5:$B$1550,"")
for next month column in the Summary for my charts, I have to manually change the sum_range to E.
Just trying to make the worksheet easily updateable with dragging over for updates. Any suggestions greatly appreciated!