title: Excel formula for searching two text in one cell and return values based on the result
body: <p>I am looking for an excel formula for searching two text(dba,BP) in one cell and return value if dba found then return dba and if BP found then return BP. I have used below formula but its only returning one value.</p>
  <p>=IF(OR(ISNUMBER(SEARCH(&quot;dba,A25)),ISNUMBER(SEARCH(&quot;bpi&quot;,A25))),&quot;dba&quot;,&quot;&quot;)</p>