title: Returning the address of a vlookup function in vba
body: <p>I've looked through all guides I can find on this subject but not a single one solves my problem.
  I want to find the cell address of this vlookup function:</p>
  
  <pre><code>vlookadd = Application.Lookup(partno, Sheet3.Range("A5:B46"), 2, False)
  </code></pre>
  
  <p>(Currently dimmed as variant incase that needs to be changed)
  I want to find the address of the value found and make it equal a variable so something like this:</p>
  
  <pre><code>batch1add = vlookadd.Address
  </code></pre>
  
  <p>The value found by the lookup function works fine but the address always comes up empty after trying lots of different possible solutions</p>