title: How to create the formula: find value from column if equals another value
body: <pre><code>Column1 Column2 Column3 Column4
  A       0       C       100%
  B       0       B       
  C       ok      D       100%
  D       ok              100%
  E       no      A       
  F       ok      F       100%
  </code></pre>
  
  <p>I want to create the formula to make the column 2 get the value from column1 and look it for in column 3 if it didn't find it, write no; if it found the value, look for the value in column4 if 100%, write ok, if didn't find 100%, write 0.</p>
  
  <p>I hope you help.. </p>