title: Match on 2 cells and return value from 3rd cell (Excel 2013)
body: <p>I have 2 worksheets.</p>
  
  <p>SHEET1 has numbers from 1-31 across Row 1.  It has a list of cars in Column A (Ford, VW...).</p>
  
  <p>SHEET2 has a list of cars in Column A, the day of the month in Column B and the condition in Column C (New, Used or Wreck).</p>
  
  <p>I need to make a match on the car and the day of the month and then retrieve the condition.</p>
  
  <p>For example:</p>
  
  <p>SHEET2 has one row that shows:
  Ford       8       New</p>
  
  <p>SHEET1 shows at the intersection of Ford and 8 - "New".</p>
  
  <p>Any help to resolve this is appreciated.  I have looked at VLOOKUP, INDEX and MATCH until I am blue in the face, but I can't figure this one out! I also looked through this site and couldn't find any similar scenarios.</p>
  
  <p>Thanks in advance.</p>