title: VLOOKUP & Inserting Text That Corresponds To The Cell
body: <p>I'm having difficulty getting my vlookup formula to pull url data from another sheet (Sheet 2) and insert added information to the url based on what is in its A cell on Sheet 1.</p>
  
  <p>For example,</p>
  
  <p>The vlookup formula <code>=VLOOKUP(B2,Sheet2!A:B,2,FALSE)</code> will check to see if B2 (Sheet 1) matches with Data on Sheet 2. It will then return the data it has matched:</p>
  
  <pre><code>=HYPERLINK("http://www.dpd.co.uk/tracking/quicktrack.do?search.consignmentNumber="&amp;Sheet1!A2&amp;"&amp;search.searchType=16&amp;search.javascriptValidated=0&amp;appmode=guest")
  </code></pre>
  
  <p>I then want the url link to insert whatever text is in the <strong>Sheet 1 A cell</strong>.</p>
  
  <p>The formula I have used does this nicely, but I want the formula to correspond down the workbook for whatever is in cell A, not just A1 i.e. Sheet 1 A3,Sheet 1 A4....</p>
  
  <p>How can I do this?</p>
  
  <p>Thanks</p>