Worksheet FormulasCell  Formula 

A3  =IF(OR(A4="",A4=0),"",INDEX($F$2:$N$15,MATCH($A$2,$E$2:$E$15,1),MATCH($A$8,$F$1:$N$1,0))) 

B3  =IF(OR(B4=0,B4=""),0,INDEX($F$2:$N$15,MATCH($B$2,$E$2:$E$15,1),MATCH($A$8,$F$1:$N$1,0))) 

C3  =IF(OR(C4="",C4=0),0,INDEX($F$2:$N$15,MATCH($C$2,$E$2:$E$15,1),MATCH($A$8,$F$1:$N$1,0))) 

A4  =IF(A$2=IFERROR(LOOKUP($B8,$A$2:$C$2,$A$2:$C$2),0),$B$8A$2,0) 

B4  =IF(B$2=IFERROR(LOOKUP($B8,$A$2:$C$2,$A$2:$C$2),0),$B$8B$2,0) 

C4  =IF(C$2=IFERROR(LOOKUP($B8,$A$2:$C$2,$A$2:$C$2),0),$B$8C$2,0) 

A5  =IF(A4=0,"",INDEX($F$2:$N$15,MATCH($B$8,$E$2:$E$15,1),MATCH($A$8,$F$1:$N$1,0))) 

B5  =IF(B4=0,0,INDEX($F$2:$N$15,MATCH($B$8,$E$2:$E$15,1),MATCH($A$8,$F$1:$N$1,0))) 

C5  =IF(C4=0,0,INDEX($F$2:$N$15,MATCH($B$8,$E$2:$E$15,1),MATCH($A$8,$F$1:$N$1,0))) 

C8  =IFERROR((B3+(B4*B5)),0)+IFERROR((C3+(C4*C5)),0)+IFERROR((A3+(A4*A5)),0)+IF(B8<=10,INDEX($F$2:$N$16,MATCH($B$8,$E$2:$E$16,1),MATCH($A$8,$F$1:$N$1,0)),0) 


Like this thread? Share it with others