Hi,

In layman's terms I want a formula that does:

(A) a series of nested IF statements with VLOOKUPS that returns a figure
(B) a series of nested IF statements with VLOOKUPS that returns another figure
(C) adds both (A) and (B) together.

My current formula is:
=IF($O$64=1,VLOOKUP(G33,SL!$G$9:$AH$33,19)*50%+IF( $O$71=1,VLOOKUP(G33,SL!$G$9:$AH$33,28,FALSE)))

and it returns a figure, multiplies it by 50%, then adds it to the other
figure from the second part of the formula. The above formula works.

What I want to do is add a series of nested IFs to both parts of the
formula; i.e.

(A)=IF($O$64=1,VLOOKUP(G33,SL!$G$9:$AH$33,19)*50%, =IF($O$64=2,VLOOKUP(G33,SL!$G$9:$AH$33,19)*40%, etc, etc

(B)IF($O$71=1,VLOOKUP(G33,SL!$G$9:$AH$33,28,if(IF( $O$71=2,VLOOKUP(G33,SL!$G$9:$AH$33,28, etc, etc.

(C) = (A)+(B)

Please help. I'll be forever in your debt!


James