Using a function to filter on two criteria

Hello,

I am having issues trying to use lookup tables in my function to allow me to filter on two criteria. I can currently filter on the date, however I can't seem to get it to work on filtering on the vertical as well.

My current formula is as below:

=IF($B$2="Full-Year",SUMIF(INDIRECT("'"&"Current Forecast"&"'!"&VLOOKUP(A4,Lookups!AL:AM,2,0)),A4,INDIRECT("'"&"Current Forecast"&"'!"&VLOOKUP($A$2,Lookups!O:Q,3,0))),SUMIFS(INDIRECT("'"&"Current Forecast"&"'!"&VLOOKUP($A$2,Lookups!O:Q,3,0)),INDIRECT("'"&"Current Forecast"&"'!"&VLOOKUP(A4,Lookups!AL:AM,2,0)),A4,INDIRECT("'"&"Current Forecast"&"'!"&VLOOKUP($B$2,Lookups!AG:AI,3,0)),VLOOKUP($B$2,Lookups!AG:AH,2,0)))/1000

I know I need to incorporate cells G:G and AF:AF in the 'current forecast tab' but not sure how to do this.

I do expect this to be a fairly large formula.

Would be grateful for any help on this.

Sorry I meant K for this extract.

Basically I want to be able to filter on the month/quarter but also filter on the vertical in the summary sheet
(the original data has thousands of lines, hence why I need a summary sheet). However at current, the data only changed when I change the date and NOT when I change the vertical.

Thanks