title: Excel vlookup with two columns in source and target returning another column
body: <p>I have a spreadsheet that has 4 columns sheet 1, and 5 columns sheet2 and I need to do a vlookup on <code>Sheet1!a2&amp;c2</code> and match the row in <code>sheet2!a2&amp;c2</code> and return <code>sheet2!c5</code>.  </p>
  
  <p>I think Index and Match would do it but all the examples have been matching a single value to an array which isn't what I need for eg.</p>
  
  <p>Can't do attachments yet :( text it is sorry for the format </p>
  
  <pre><code>Sheet1
  R1   A  B  C  D
  R2   2  D  3  Result will match sheet1!a2&amp;c2 to sheet 2!A3&amp;C3 and return Sheet2!e3 ie 34
  
  Sheet2
  R1   A   B  C  D   E
  R2   2   F  5  GR  72
  R3   2   X  3  FR  34
  </code></pre>
  
  <p>Any links or help?</p>
  
  <p><strong>Update</strong>
  Sorry I wasn't clear I want to match the cobination of A2 and C2 in sheet 1, </p>
  
  <pre><code>ie in the example =sheet1!A2&amp;sheet1!c2=23
  </code></pre>
  
  <p>to the values in sheet2!a2 plus sheet2!c2, </p>
  
  <pre><code>ie in this example =Sheet2!a3&amp;Sheet2!c3=23, 
  </code></pre>
  
  <p>and then return the value in Sheet2!E? , ie Sheet2!E3=34 here</p>
  
  <p>I've done this before by creating a cheat column in sheet 2 = a2&amp;c2 in say d2 and filling down then using, assuming 3 rows, however I can't create the cheat column in sheet2</p>
  
  <pre><code>=vlookup(a2&amp;c2,sheet2!d2:e3, 2, false) 
  </code></pre>
  
  <p>The rows sheet2! look like, sorry about the formatting</p>
  
  <p>Picture attached, which I suddenly got to do , where I need to match the yellow columns in the lookup then return the brown column to sheet1!E2 but I can't add the cheat column Sheet2!d2:3 to the sheet cause the user is difficult :)</p>
  
  <p>Thanks again. Any good tutorial on Index?</p>
  
  <p><img src="https://i.stack.imgur.com/My0Ov.png" alt="Sheet &amp; Formula example"></p>