title: Reference a cell using formula?
body: <p>In Google Sheets I need to reference a cell by (column, row) in a way where I can replace "row" with a formula to find a specific row. In other words I can't use a reference like "A7" because my row is determined by a formula.</p>
  
  <p>Here is the formula that gives me my row number: </p>
  
  <pre><code>=ArrayFormula(MAX(FILTER(ROW(B:B);NOT(ISBLANK(B:B)))))
  </code></pre>