title: How to use ROW() in an Excel VLOOKUP formula?
body: <p>I have two formulas for a cell reference: <code>="D"&amp;ROW()</code> and <code>="D$"&amp;(ROW()-1)</code></p>
  
  <p>These work fine on their own, but not when I put them in a VLOOKUP:
  <code>=VLOOKUP("D"&amp;ROW(),D$3:"D$"&amp;(ROW()-1),1,0)</code></p>
  
  <p>Using the <code>ADDRESS</code> function gave the same error as using the <code>ROW</code> function. I have successfully worked around this using <code>INDIRECT</code> in the <code>VLOOKUP</code> formula, but that seems clunky and unnecessarily complicated. Is there a way to do this without using <code>INDIRECT</code>?</p>