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
0
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.
0

Similar discussions

Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response
i can't enter to my account facebook
susi -
Ambucias -

1 response
Yahoo account reactivation
Senkumba -
kitkat55 -

2 responses
someone hacked my fb account and changed my password
mik -
aceventura12345 -

13 responses
Couldn't find your Google account
Muzammil -
HelpiOS -

1 response