If Function, Indirect & Vlookup to return based on two requirements

Hello.

I have attached an extract of the data and what I am trying to achieve.

My current formula is:

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

However it does not seem to be returning anything.

Thank you

Elouise