Hi all,

As shown in the pic attached, cell E4 has a drop-down selection of Price A, Price B and Price C.

Here is what I would like to achieve:

When E4=A4(or Price A), the column E6 to E22 = D6*A6
When E4=B4(or Price B), the column E6 to E22 = D6*B6
When E4=C4(or Price C), the column E6 to E22 = D6*C6

So then whenever I click on my drop-down and select one of the prices, the equation formula in the entire E column will switch accordingly, does this make sense?

Please help, thanks heaps! ^_^

example.jpg