Search for fiscal quarter and year

I had to modify the formula to return the correct fiscal year: January-May are always in the current fiscal year, and June-December are the next fiscal year.

The following formula replaced YEAR(TODAY) with a LOOKUP referencing a Month/Year lookup table.

=SUM($J89:INDEX($J89:$IV89,MATCH("*"&$D$88&" "&LOOKUP(MONTH(TODAY()),$B$140:$B$151,$C$140:$C$151),$J$88:$IV$88,0)-1))

However, there seems to be a problem with the INDEX... -1, as the sum includes the current quarter, whereas the original formula summed to the prior quarter, which was what I wanted.

Can you tell me what's wrong?