A B C D
E F

Daffy Duck 1/1/2007 SE3 30 2.69 80.70
Donald Duck 1/2/2007 SE2 1 2.23 2.23

When I type in cell C, I need I to generate the correlating number into E
and then multiply with D to and total in F.