title: excel vlookup lookup_range cell contains a formula
body: <p>I have a straightforward formula in Excel 2010 as follows:</p>
  
  <pre><code>=VLOOKUP(D597,'Sheet1'!$AA$3:$AC$5000,3,FALSE)
  </code></pre>
  
  <p>The problem is the lookup_range, D597 in this case, contains a formula, not text or numbers (it is actually a reference to another sheet and cell).</p>
  
  <p>The lookup is returning #N/A . I know the value is in the named range, column aa, and the value I want in column 3.</p>
  
  <p>Is there a way to use vlookup, or another function, to accomplish this fairly straightforward lookup?</p>