Filter or Lookup Formula to Organize Keywords

		Microsoft Office Forums > Microsoft Excel > Excel
Filter or Lookup Formula to Organize Keywords

FAQ

Thread Tools

Display Modes

11-26-2018, 05:18 AM

ArviLaanemets ArviLaanemets is offline

Filter or Lookup Formula to Organize Keywords

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 932

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)
     )
)

Tags

filter formula, lookup formula

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:11 PM.