title: Return a cell reference for use in a formula
body: <p>I have an excel workbook with paired data sets of the type <code>[columnA=time:columnB=data]</code>
  There are thousands of data points.</p>
  
  <p>What I'm looking to do is this: I have a table of time values on a separate sheet.  I want to find the corresponding cell in the data column of the data worksheet (column B) and return an average of the values of 5 cells before it and 40 cells after it.</p>
  
  <p>By searching the questions I came up with this formula to return a cell address of the exact value I'm looking for, however I can't put it into an average formula.</p>
  
  <pre><code>=CELL("address",INDEX('EMG Data'!B1:B10000,MATCH(C5,'EMG Data'!A1:A10000,0),1))
  </code></pre>
  
  <p>C5 is the time value I know I want to get the data value pair for.</p>