searchingforhelp
Board Regular
- Joined
- Nov 11, 2020
- Messages
- 67
- Office Version
- 365
- Platform
- Windows
Hello,
I am attempting to no avail combine two formulas. My goal is to locate a specific word in a cell that contains other characters/ words by utilizing the SEARCH function. If the word is located in a cell, I would like another cell to indicate "Found". If the word is not located in the cell, it will indicate "Not Found"
Below are two function I am attempting to combined:
=IF(SEARCH(B5,B2),"Found")
=IFERROR(SEARCH(B5,B2),"Not Found").
Below (or attached) is an image I am referencing with the formulas above.
Lastly, is there a way in using the functions above to search multiple columns for the same word? I written a separate sentence in F2 for an example.
Greatly appreciate any help I can get and if possible can the formulas be separated per question so I can distinguish between the formulas for learning purposes.
Thanks!!
I am attempting to no avail combine two formulas. My goal is to locate a specific word in a cell that contains other characters/ words by utilizing the SEARCH function. If the word is located in a cell, I would like another cell to indicate "Found". If the word is not located in the cell, it will indicate "Not Found"
Below are two function I am attempting to combined:
=IF(SEARCH(B5,B2),"Found")
=IFERROR(SEARCH(B5,B2),"Not Found").
Below (or attached) is an image I am referencing with the formulas above.
Lastly, is there a way in using the functions above to search multiple columns for the same word? I written a separate sentence in F2 for an example.
Greatly appreciate any help I can get and if possible can the formulas be separated per question so I can distinguish between the formulas for learning purposes.
Thanks!!