title: Excel - "referencing"
body: <p>I have two columns, B and F. In F, I have a formula and then I apply it through entire column F, but this formula should have the same 'cell number' as it is in <strong>B</strong>, e.g. cell B5 has formula =Sheet2!$C$<strong>9</strong> and then:</p>
  <p>F5 should have =Sheet2!$D<strong>9</strong>   --- I will write the first 'cell letter' (D)</p>
  <p>F6 should have =Sheet2!$D<strong>4</strong>   --- B6 =Sheet2!$C$<strong>4</strong></p>
  <p>F7 should have =Sheet2!$D<strong>11</strong>   --- B7  =Sheet2!$C$<strong>11</strong>
  ...</p>