title: Multiple criteria to display specific text
body: <p>Formula help required to display the desired result with multiple criteria in cells.</p>
  
  <p>In the below table D2 cell the formula is added to to show the result eg: F2 cell. The criteria of finding the specific text in A2 cell is the blocker in the function to give the desired result</p>
  
  <p><a href="https://i.stack.imgur.com/FHkpt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FHkpt.png" alt="enter image description here"></a></p>
  
  <pre><code>=IF(AND(ISNUMBER(SEARCH("FF",A2)),B2=1,C2="MC"),"Fotp"),IF(AND(ISNUMBER(SEARCH("2D",A2)),B2=1,C2="MC"),"2D"),IF(AND(ISNUMBER(SEARCH("MF",A2)),B2=5,C2="MC"),"Modfix"),IF(AND(ISNUMBER(SEARCH("SE",A2)),B2=0.7,C2="SE"),"SoEv"),IF(AND(ISNUMBER(SEARCH("M Cat",A2)),B2=19,C2="MC"),"Mcat"),IF(AND(ISNUMBER(SEARCH("M cod",A2)),B2=1.25,C2="MC"),"Ing")
  </code></pre>