title: Reading and executing formulas from text
body: <p>I have a problem where I have a need to execute a complex formula saved as text.
  I can only find VBA and EVAL() solutions, which cannot be used in my situation.</p>
  
  <p>For example, I have a cell with:</p>
  
  <pre><code>IF(VLOOKUP($A1;Summary!$E:$K;1;TRUE)=$A1;VLOOKUP($A1;Summary!$E:$K;7;TRUE);0)
  </code></pre>
  
  <p>and I would like a formula in another cell to have the result obtained when running the example formula.
  I get a #REF! error when trying INDIRECT()</p>
  
  <p>Edit: Basically, is there a way to run EVALUATE() formula without defining your own formula through "Name manager" that does just that.</p>