Thread: Issues with populating cells dependent on other inputs.

I am attempting to populate a cell automatically depending on the input of another cell.

Say for example Cell A1 = 1, then cell A2 would automatically = 100,

I have set up a reference table on another sheet with the initial values (e.g. A1) and required reference (e.g. 100) in a table form,

Can you direct me in the right direction in order to set this up?

Thanks,

Charlie