Entered in E2 try
=IF(LEFT(B2,1)="3","",D2*(IF(C2<DATE(2012,11,14),VLOOKUP(LOOKUP(REPT("z",255),$A$2:A2),SinglePoints,2,0),VLOOKUP(LOOKUP(REPT("z",255),$A$2:A2),DoublePoints,2,0))))
and pull down as needed