Forum Discussion

RKD2313's avatar
RKD2313
Copper Contributor
Apr 10, 2022

How To Search For Multiple Words With "Find"

The Excel Sheet is my bank statement, so I cant share that, but I can explain well enough that a visual shouldn't be needed. The Data is only 4 Columns (A-D) (A) Date    |   (B) Type of Transaction...
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 10, 2022

RKD2313 Begin by assigning a name to the range that contains the keywords, for example "KeyWords".

 

Then in E2 enter this formula:

=IFERROR(INDEX(KeyWords,MATCH(TRUE,(ISNUMBER(SEARCH(KeyWords,B2,1))),0),1),"")

and copy it down. It should return the first keyword found in the text in column B if it finds at least one of the keywords.

RKD2313's avatar
RKD2313
Copper Contributor
Apr 10, 2022

In your example, using "KeyWords" as the term, wouldn't this just result in finding rows where "KeyWords" matches? Im not sure Im grasping what you're saying. If I am understanding, even somewhat, "Keywords" is only 1 search term? If I have 500 Rows of the best fast food chains in USA State by State and I want to rid all rows containing "Burger King" "McDonalds" "Sonic" "Arbys" "Subway" "Chilis" etc etc, but these keywords are randomly placed throughout those 500 Rows, how can I search for all of those keywords + Delete Rows containing mentioned restaurants in 1 go (If thats even possible).

If I dont understand you, but you understand me, I apologize

Resources