title: return a row number from a vlookup in vba
body: <p>I need to know what code to use in this situation.  </p>
  
  <p>I am using vlookup in vba to locate a certain record number.  I then need to know what row number the record is located in.  I have tried the following, but received errors:</p>
  
  <pre><code>nRowSavedRecord = [Vlookup(Cells(nRows, nColRecNmbr),Range("RecordInfo"),2,False).Row]
  </code></pre>
  
  <p>This gives me a "<code>Type Mismatch</code>" error.</p>
  
  <p>or</p>
  
  <pre><code>nRowSavedRecord = Application.vlookup(cells(nRows, nColRecNmbr), Range("RecordInfo"),2,False).Rows
  </code></pre>
  
  <p>This gives me an "<code>Object Required</code>" error.  </p>
  
  <p>I'm sure whatever I'm missing is simple.<br>
  (<code>nRowSavedRecord</code> is a <code>Long</code>)
  Can anyone help?</p>
  
  <p>Thanks!</p>