Multiple "IF" formula question

[elfiky]

Please see attached. I need to tweak the formula to add another layer of (IF) statement to pull data from corresponding tables per selected criteria. Thanks in advance

[martindwilson]

=IF(ISERROR(W2),X2,(+X2+W2)-((+X2+W2)*VLOOKUP($B2,'CWExp & Template Titles'!$A$5:$B$18,2,FALSE)))
why the iserror ? there is nothing in column w to give an error

oh and use in col j
=IF(OR($J2={"lost","Canceled","Cancelled"}),"Canceled",TEXT($Q2,"YYYY"))
other bits are cluttered
=IF(OR(SUM($Y2)=0,SUM($AG2)=0) is the same as =IF(OR($Y2=0,$AG2=0) or even just if($y2*$ag2=0

[NBVC]

Try, in AJ2:

Please Login or Register  to view this content.

copied down and across.

This Part added in IFERROR(MATCH($M2,'Spend Curve'!$A:$A,0)-1,0) offsets to the corresponding table, if it exists in the other sheet, otherwise it use the top default table

[Bob Phillips]

It looks as though you want

=IF(OR($Y2=0,$AG2=0),0,IFERROR(MAX(0,$Y2*INDEX('Spend Curve'!$B$2:$R$15,
MATCH($M2,'Spend Curve'!$A:$A,0)+MATCH($B2,'Spend Curve'!$A$1:$A$15,0)-1,
12+((YEAR(AJ$1)*12+MONTH(AJ$1)-12)-($C2*12+MONTH($Q2)-12)))-SUM($AA2,$AI2:AI2,-$AI2)),0))

but this returns all zeroes.