title: Excel substitute for FIND Function when searching for multiple criteria
body: <p>I want to find whether a given cell has a value that is included in a list.  Then I want to make the equation dynamic so that it results in a different output based on which item in the list it is.  There should be an equation in column B (Index/Match?) that returns a value from column D based on whether the value in column A contains one of the codes in Column C.</p>
  
  <pre><code>Column A     Column B              Column C    Column D
  ABC12D       Equation=$40          ABC         $40
  XYZ15Q       Equation=$20          MNO         $30
  MNO26P       Equation=$30          XYZ         $20
  </code></pre>