title: Excel if the cell value from columns 1 and 2 match, insert a value from cell 2's row into another cell of cell 1's row
body: <p>I need to find the row X in SHEET2 which contains the same value in its coulmn A (there is one such value in the entire Column A) that matches Column C value of my current cell on SHEET1 and then put the value from SHEET2 row X's column D into the current cell where I am entering the formula you hopefully provide to me :)))</p>
  
  <p>I tried this:</p>
  
  <pre><code>="SHEET2!D"&amp; MATCH('SHEET1!C16,SHEET2!A:A,0)
  </code></pre>
  
  <p>instead of entering the value it inserts:</p>
  
  <pre><code>DBW!D110
  </code></pre>
  
  <p>So it does find the correct row (#110 in this case) and DBW!D110 is the correct cell, how do I get its value (an not its cell #)?</p>