title: Excel Data Mapping (similar to a join or where clause)
body: <p>I have an excel workbook that has 2 sheets.
  One sheet has 580 rows, the other has 187.</p>
  <p>I have a list of names that will need to be mapped to the appropriate column based on a common column in both sheets.</p>
  <p>Column D in sheet 1 and Column B in sheet 2 both contain &quot;program names&quot;
  Column A in Sheet 2 contains text about certain programs, but not all programs have text.</p>
  <p>I need to get the program text for 'Sheet2'!A2:A187 into 'Sheet1' Column C.</p>
  <p>Basically the logic would look like this:</p>
  <blockquote>
  <p>Find Program Text 'Sheet2'!A2:A187</p>
  <p>WHERE</p>
  <p>'Sheet1':D(current row) = 'Sheet2'!B2:b187</p>
  </blockquote>
  <p>I'm just not exactly sure how to do it in excel.  I tried LOOKUP, but that didnt seem to do what I wanted exactly.</p>