Dynamic Reference with Offset

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.

Here is an example file for your review.

Thanks

Has anyone had a chance to look at my request? If more information is needed please let me know.