title: IFS Formula in Google Sheets
body: <p>I am looking for a formula in Google Sheet.</p>
  <p>The formula is based on an &quot;Imput&quot; sheet and &quot;Output&quot; sheet. In the &quot;Imput&quot; sheet there are following columns:</p>
  <pre><code>current_position, company_name, current_position_2, current_company_2
  </code></pre>
  <p>In the &quot;Output&quot; sheet there are &quot;Title&quot; and &quot;Account name&quot; <a href="https://i.stack.imgur.com/YTYht.png" rel="nofollow noreferrer">Imput</a> + <a href="https://i.stack.imgur.com/rsCHw.png" rel="nofollow noreferrer">Output</a></p>
  <p>The formula should be in &quot;Title&quot; in &quot;Output&quot; and say:</p>
  <p>1)</p>
  <p>If &quot;current_position&quot; contains &quot;COO&quot;, &quot;CEO&quot;, &quot;CSO&quot; (and a lot more titles) then take &quot;company_name&quot; and put in &quot;Account Name&quot; under &quot;Output&quot;.</p>
  <p>2)</p>
  <p>If &quot;current_position&quot; does not contain &quot;COO&quot;, &quot;CEO&quot;, &quot;CSO&quot; (and a lot more titles) AND &quot;current_position_2&quot; contain &quot;COO&quot;, &quot;CEO&quot;, &quot;CSO&quot; (and a lot more titles) then put &quot;current_position_2&quot; in &quot;Title&quot; in &quot;Output&quot; and &quot;current_company_2&quot; in &quot;Account Name&quot; in &quot;Output&quot;</p>
  <p>3)</p>
  <p>If neither of &quot;current_position&quot; or &quot;current_position_2 contains &quot;COO&quot;, &quot;CEO&quot;, &quot;CSO&quot; (and a lot more titles) then take &quot;current_position&quot; and put in &quot;Title&quot; under &quot;Output&quot; and &quot;Current_position_2&quot; and put in &quot;Account Name&quot; in &quot;Output&quot;</p>