title: Check if an excel cell exists on another worksheet in a column - and return the contents of a different column
body: <p>What I want to do is to say if the contents of cell <code>D3</code> (on current worksheet) exist in column <code>A</code> in the first worksheet (in my case entitled list). (and they always do exist somewhere). Return the contents of the corresponding row in Column <code>C</code>. </p>
  
  <p>In other words if the matching cell is found in Row <code>12</code> - return data from <code>C12</code>.  </p>
  
  <p>I've used the following syntax but I can't seem to get the last part to work correctly. </p>
  
  <pre><code>=IF(ISERROR(MATCH(D3,List!A:A, 0)), "No Match", VLOOKUP(D3,List!A:A,1,TRUE))
  </code></pre>
  
  <p>How to fix the formula?</p>