title: Need to obtain value based on 2 criteria with or
body: <p>I need a help to return a &quot;Yes&quot; or &quot;No&quot; based on different responses from the same company</p>
  <p>the criteria is:</p>
  <ul>
  <li>if any employee responded &quot;Sim&quot; (=&quot;Yes&quot;) the result should be &quot;Yes&quot; for that company</li>
  <li>&quot;no&quot; if all responders filled as &quot;Não&quot;</li>
  </ul>
  <p>In the Image:</p>
  <ul>
  <li>For BIO - should be YES</li>
  <li>For ALA      - should be NO</li>
  </ul>
  <p>tried to use INDEX MATCH but couldnt</p>
  <p><strong>Data</strong><br />
  <a href="https://i.stack.imgur.com/QwKWQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QwKWQ.png" alt="Data" /></a></p>
  <p><strong>EDIT:</strong>
  I'm having problems compiling answers according to each company
  In column &quot;I&quot; i would like to have the result for each company.</p>
  <p><strong>DataComp</strong><br />
  <a href="https://i.stack.imgur.com/QwKWQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DioBU.png" alt="DataComp" /></a></p>