I have months and the year in col B4:M4 in destination workbook
I am trying to set up a formula to do extract a value from row 7 in the source file where the month and year in Col C1:N1 matches B4 in the destination file.
It would be appreciated if someone could kindly assist me in amending my formula so that I get the correct result where the month and years matches. if the month & year match extract value from Row7 , otherwise return 0
I am trying to set up a formula to do extract a value from row 7 in the source file where the month and year in Col C1:N1 matches B4 in the destination file.
Code:
=OFFSET('[Sales ACCNTS(P).xls]Summary'!$C$7,MATCH(B4,'[Sale ACCNTS(P).xls]Summary'!$C$1:$N$1,0),3,0)It would be appreciated if someone could kindly assist me in amending my formula so that I get the correct result where the month and years matches. if the month & year match extract value from Row7 , otherwise return 0
