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 tr...
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 :)
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