I currently have a formula that uses on offset formula to return a value based on which column (month) that the value resides. I currently have hardcoded the line that needs to be returned and if the source data changes in size my formula will have to be manually updated.
=IF(+Info!$B$8-11>0,-OFFSET('Q - Inc. Stmt. by Month_CY'!$F10,0,Info!$B$8-23,1,1),-OFFSET('Q - Inc. Stmt. by Month_PY'!$Q11,0,+Info!$B$8-11,1,1))
Info!$B$8 equal current month (i.e. 6=June)
I am using an If statement to switch between two data ranges based on if it is Prior Year or Current Year. (The result is a rolling twelve month financial)
I have a GL Node (i.e. "1065" = "Net Income") that I would like to reference to allow for a dynamic result.
I believe and Index Function would work, but I am unsure how to set it up.
Thanks,
For you assistance.
Bookmarks