title: Formula in Google Spreadsheet to display the value of one cell in another cell where the number of columns between the cells is a controlled variable?
body: <p>How do I create a formula in Google Spreadsheet which will display the value of one cell (eg cell A2) in another cell (eg C3) where the number of columns between the cells (n) is a controlled variable (in this example "2")?</p>
  
  <p>Use case: I have a cash-flow model broken down by weeks in columns and want to show revenue 'n' number of weeks after deal has been signed, where I can manipulate one cell (representing the value of 'n') to see the impact on the model.</p>