title: IS there a do not match function
body: <p>I am trying to do 2 functions. The first is to match all the values (text) from 1 range with another and return the values that match. I would also like a second formula that returns the values that do not match. The 2 lists may not be in the same order nor can they be as they are ranked. </p>
  
  <pre><code>=IFERROR(INDEX($L$4:$L$23,MATCH($B15,$L$4:$L$23,0)),$L15&amp;" Different")
  </code></pre>
  
  <p>Could anyone suggest an answer?</p>
  
  <p>Thank you in advance</p>