Microsoft Office Forums - View Single Post - [Solved] Filter or Lookup Formula to Organize Keywords

MKTGCLOUD · 11-26-2018, 05:55 PM

Quote:

Originally Posted by ArviLaanemets

Maybe a single column (and formula) will do?

Code:

=IF(
     IFERROR(1*(FIND("doctor",$A2)>0),0)+IFERROR(2*(FIND("professor",$A2)>0),0)=0;
     "",
     INDEX(
          {"doctor";"professor";"doctor and professor"},
          IFERROR(1*(FIND("doctor",$A2)>0),0)+IFERROR(2*(FIND("professor",$A2)>0),0)
     )
)

Thanks for the formula. This works on a singular column, but need to distinguish those keywords with a "doctor" and "professor" in it.