Excel formula for searching two text in one cell and return values based on the result

Question

I'm looking for an Excel formula that would search two text strings (dba, BP) in a single cell and return values based on whether dba or BP was found. I used the formula below, but it only returned one value.

=IF(OR(ISNUMBER(SEARCH("dba,A25)),ISNUMBER(SEARCH("bpi",A25))),"dba","")

Answer 1

You can include a second IF within the first one so that it functions as though it is testing for a second case if the first case does not match.

=IF(<first case>, <first case matched> ,IF(<second case>, <second case matched>, <no matches>))

In your case,

=IF(ISNUMBER(SEARCH("dba",A1)),"dba",IF(ISNUMBER(SEARCH("bpi",A1)),"bpi",""))