Previous Topic Next Topic

Formula to seach for matching text contained

Closed
RFris - Jun 28, 2010 at 12:54 PM
 rfris - Jun 30, 2010 at 01:41 PM
Hello,

I am looking for a formula that will search for key words from one column to another. Specifically, I have a large list of product descriptions and I have a list of about 60 key words. I want to use a formula that will look within the product description column to find any of the 60 words from my key word searches and return a value (anything) that will let me sort or filter to identify quicker.

Usually I do this manually by using filters and the contains options. But my list usually only contains a few words. Since I have a larger list this time I was hoping to find a formula to help.

Anyone have any advice?

Thanks so much!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 28, 2010 at 05:58 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
rfris
Jun 30, 2010 at 01:41 PM
I am having some trouble uploading a sample file to one of these share sites. I think I will have to do it from home tonight. It may be a problem with the computers permissions at my work. I will be sure to post tonight. Thanks for your help.

Similar discussions

Orkut forget login id and password
Rajan thakur -
HelpiOS -

5 responses
Login my old Orkut account.
raja mondal -
BunoCS -

1 response
Getting email from Instagram a couple of years after deleting my account
TA_questions -
Sara -

2 responses
Reactivating an old AOL account they deleted
bingorood -
Ambucias -

1 response