I made a validation list in A1 for different scenarios, I could choose 3
different secnarios from this drop-down list.

each time, when I choose one scenario, there is a result in B2, for instance
if I choose scenario1 in A1, b1=100; choose scenario2,b1=200; choose
scenario3, b1=300.

The question is,
Can I make c1, c2 and c3 store b1 value based on different choosen scenario?
For example, I choose scenario1 in drop-down list in A1, b1 show equal to
100, c1 store a result 100; if I change my choice in drop-down list to
scenario2, b1 will be 200, but c1 will still keep 100 result, at the same
time c2 will be 200.

I tried Iteration function in Excel sheet, but it doesn't work, I THINK vba
might be the only choice. could someone help me out?

Thanks in advance.