Based on the table above Column C3 uses formula like =SUM(B3*$C$1). Use the lookup formula instead and still get the same answer. Write out the lookup formula for C3:C7.

\begin{tabular}{|l|l|l|l|l|l|} \hline & \multicolumn{1}{|c|}{ A } & B & C & D & E \\ \hline 1 & & & 1.9 & & \\ \hline 2 & QUANT & & & & \\ \hline 3 & 1200 & 1.2000 & 3.1454 & 0.7700 & 0.8500 \\ \hline 4 & 200400 & 0.9200 & 2.5470 & 0.7500 & 0.7700 \\ \hline 5 & 400600 & 0.4600 & 1.2355 & 0.7400 & 0.7500 \\ \hline 6 & 600800 & 0.2800 & 0.5794 & 0.7000 & 0.7400 \\ \hline 7 & 8001000 & 0.2300 & 0.5830 & 0.6800 & 0.7000 \\ \hline 8 & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline & \multicolumn{1}{|c|}{ A } & B & C & D & E \\ \hline 1 & & & 1.9 & & \\ \hline 2 & QUANT & & & & \\ \hline 3 & 1200 & 1.2000 & 3.1454 & 0.7700 & 0.8500 \\ \hline 4 & 200400 & 0.9200 & 2.5470 & 0.7500 & 0.7700 \\ \hline 5 & 400600 & 0.4600 & 1.2355 & 0.7400 & 0.7500 \\ \hline 6 & 600800 & 0.2800 & 0.5794 & 0.7000 & 0.7400 \\ \hline 7 & 8001000 & 0.2300 & 0.5830 & 0.6800 & 0.7000 \\ \hline 8 & & & & & \\ \hline \end{tabular}