I need some help, please
I have 2 worksheets with headers....ws2 is the master with 20 names as header and below (ROW 2) a formula {=SUMPRODUCT((Sheet1!$A$1:$XQ$1=A$1)*(Sheet1!$Z$2:$Z$39=Sheet1!$A$2:$A$39))} and ws1 has 9 names as header, (the names of the headers are the same), and below (ROW 2 - ROW 39) data, I want to check for MATCHING each of the 9 names of the header ws1 with the header of the ws2, IF the name Match I need to Replace $Z$2:$Z$39 in the formula for the column's letter of the ws1, where the match was found, ex...if the match was in column D of the ws1, the formula will be {=SUMPRODUCT((Sheet1!$A$1:$XQ$1=A$1)*(Sheet1!$D$2:$D$39=Sheet1!$A$2:$A$39))}.
Thank a lot
I have 2 worksheets with headers....ws2 is the master with 20 names as header and below (ROW 2) a formula {=SUMPRODUCT((Sheet1!$A$1:$XQ$1=A$1)*(Sheet1!$Z$2:$Z$39=Sheet1!$A$2:$A$39))} and ws1 has 9 names as header, (the names of the headers are the same), and below (ROW 2 - ROW 39) data, I want to check for MATCHING each of the 9 names of the header ws1 with the header of the ws2, IF the name Match I need to Replace $Z$2:$Z$39 in the formula for the column's letter of the ws1, where the match was found, ex...if the match was in column D of the ws1, the formula will be {=SUMPRODUCT((Sheet1!$A$1:$XQ$1=A$1)*(Sheet1!$D$2:$D$39=Sheet1!$A$2:$A$39))}.
Thank a lot