title: Excel VLOOKUP and FIND combination
body: <p>I have two columns, A and B, containing values. I want to insert values in a C column where each of these are contained in both A and B.</p>
  
  <p>Example of my desired result:</p>
  
  <pre><code>A         B         C
  
  Hello     No        No
  Nothere   here      here
  YesNo     ha
  </code></pre>
  
  <p>As "here" is contained in "Nothere", it must be added. Same as "No" in "YesNo"</p>
  
  <p>As far as I know, I can use FIND to find out if the string exists and VLOOKUP to search for the entire column. But how can I use FIND in the entire column? Because with VLOOKUP I must search for a specific value, and it will be changing from column to column.</p>
  
  <p>How can I achieve this? (I don't need to use FIND nor VLOOKUP, I just mentioned this as research I was doing).</p>