In Windows!F2, try this formula:

=D2*VLOOKUP(C2,Table7,2,1)*IF(E2="No Capping",0.85,1)
Cheers,