title: controlling a formula with the value from another cell
body: <p><img src="https://i.stack.imgur.com/oeJKk.png" alt="enter image description here"></p>
  
  <p>This is a very basic example.
  <br>What is in A3 and A4 are the formulas that are in B3 &amp; B4 respectively.
  <br>
  <br>I want the value in B4 to be "ValueB2"(the value from B2)
  <br>I basically want to control the formula in B4  with a value from another cell(C4)
  <br>Can this be done or how do I do it?</p>