Match Keyword in Excel

[Mohanmoni]

Hi,

I am looking for excel formula i.e matches keyword in entire column. for example in "Column A" i have 1000 list of details about products. Now i want to find who are using product "Red", "Green", "Orange"......etc

Column "A"
ABC Red
Green XYZ
Orange GHI
--
--
--

Please get me formula for find the cell that contains above keyword (Red, Green, Orange...)

Regards,
Mohan

 

[Aladin Akyurek]

What is the output that you require for the sample you posted?

 

[Mohanmoni]

I want to see the list that contains the keyword (Red, Green, Orange...etc) in "Column A"

 

[BrianJN1]

Hi,

I am looking for excel formula i.e matches keyword in entire column. for example in "Column A" i have 1000 list of details about products. Now i want to find who are using product "Red", "Green", "Orange"......etc

Column "A"
ABC Red
Green XYZ
Orange GHI
--
--
--

Please get me formula for find the cell that contains above keyword (Red, Green, Orange...)

Regards,
Mohan

We would want more details if to assist. Firstly your example is confusing as the initial entry is not consistent with the other two.
Secondly, are those products replicated in that list?
Lastly, where are the clients/users located, and are their names also likely to be replicated?

Um? What do you wish as an outcome? Like, how would you see your report?

I'm unlikely to develop any of that, but they are questions that clearly need to be answered.

 

[Mohanmoni]

Title	Keyword		Title_Result	Keyword
Technology - Compliance and Business Continuity	Human Resource		Technology - Compliance and Business Continuity	Technology
Foundation Training Operations	Operation		Foundation Training Operations	Operation
Human Resource Supervisor	Information Technology		Human Resource Supervisor	Human Resource
Vendor Training Operations	Engineering		Vendor Training Operations	Operation
Industry and Application Delivery Training Operations			Industry and Application Delivery Training Operations	Operation
Vice President, Claim Operations			Vice President, Claim Operations	Operation
Managing Director, Underwriting Operations			Managing Director, Underwriting Operations	Operation
Information Technology Manager			Information Technology Manager	Information Technology
Director of Servicing Carrier Operations			Director of Servicing Carrier Operations	Operation
Vice President, Claim Operations			Vice President, Claim Operations	Operation
Vice President - Regional Operations			Vice President - Regional Operations	Operation
Senior Global Information Technology Officer			Senior Global Information Technology Officer	Information Technology
Vice President Global Operations Compliance			Vice President Global Operations Compliance	Operation
Information Technology Manager			Information Technology Manager	Information Technology
Associate Director Engineering Operations			Associate Director Engineering Operations	Engineering

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

Please check above example.

 

[Aladin Akyurek]

Let column A house the data.

Let a convenient range somewhere else house the relevant keywords. Name this range KeywordList via the Name Box or the Name Manager. It's advisable to sort this list in ascending order.

In B2 enter and copy down:

=LOOKUP(9.99999999999999E+307,SEARCH(" "&KeywordList&" ",$A2),KeywordList)