Jan 07 2020 06:40 AM
Im sure there is a million of these on here but I have been spinning my wheels on this for a day.
Two issues
I'm trying to do a year to date formula on a deck tab linked to a large P&L tab. If im looking up March instead of pulling year to date (Jan, Feb, Mar) it is pulling Mar, April, May.
The other issue is im pulling a balance sheet with a month to date and it is pulling other balance sheet cells. Here is the file and the two formulas. I am trying to make this automated so I can change a date in one tab and the whole model works, these are the last issues im having.
YTD Formula
=SUMIF(IS!$P$7:$AA$7,"YTD",(INDEX(IS!$P$11:$AA$77,MATCH('YTD Summary'!A6,IS!$A$11:$A$77,0)*MATCH('YTD Summary'!$C$5,IS!$P$8:$AA$8,0),MATCH('YTD Summary'!$B$1,IS!$P$9:$AA$9))))
Balance Sheet
=INDEX(BS!$A$8:$AX$70,MATCH('Balance Sheet'!A5,BS!$A$8:$A$70),MATCH('Balance Sheet'!$C$1,BS!$A$7:$AX$7))