Forum Discussion
Solved
Excel Formulas
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:)
Hi Fredrik,
Perhaps like
=IF(SUMPRODUCT(ISNUMBER(SEARCH(G:G,B5))*NOT(ISBLANK(G:G))),"Test","")
Please see attached
3 Replies
Hi Fredrik,
Perhaps like
=IF(SUMPRODUCT(ISNUMBER(SEARCH(G:G,B5))*NOT(ISBLANK(G:G))),"Test","")
Please see attached
- 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 :)You are welcome
