title: how to use Variables inside vlookup of Formula R1C1?
body: <p>Selection.FormulaR1C1 = &quot;=IF(RC[-1-&quot; &amp; NofRanks &amp; &quot;]&gt;R4C3,RC[-4-&quot; &amp; NofRanks &amp; &quot;]/R2C3,0)&quot;</p>
  <p>I don't understand why it's giving me a syntax error. Can someone please help?</p>
  <p>Here NofRanks is a variable-integer.</p>