Filter or Lookup Formula to Organize Keywords

MKTGCLOUD · #3 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with lookup formula	tristanlau	Excel	1	08-14-2017 07:16 AM
Formula help please (lookup across multiple sheets)	froggybsb03	Excel	2	03-16-2017 02:16 AM
lookup or filter data, update it and save it	fre_	Excel Programming	3	06-06-2016 08:54 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
Best way to organize resources	Steve.	Project	3	05-17-2014 07:07 AM