Excel Formulas

[Fredrik123]

Hi. I'm pretty new to Excel and its functions. 

I need to make myself a formula to find something within a column, which matches something within a cell. This cell has more than one word. I're tried this as an example:

=IF(FIND(B5; G:G); "Test"; "")

The problem that keeps on occuring is that it takes the first thing that seems close to some of the words.

B5="I need to learn"   In the collumn I can have: "Cool, Too, Test and TO" It seems to take Too,

everytime. This would have been easy if the cells on column B had been standarised, but they're not. So sometimes the word to search is in the end, and sometimes middle.

Please help:)

[#2 · Accepted solution]

Hi Fredrik,

Perhaps like

=IF(SUMPRODUCT(ISNUMBER(SEARCH(G:G,B5))*NOT(ISBLANK(G:G))),"Test","")

Please see attached

[#3]

Hi and thank you for the formula.
It worked in the end. Now I just have to tweak it in to my original and I'm good to go.

Thank you for your help :)

[#4]

You are welcome