Forum Discussion
Keywords in one column to populate another
I have a file we’re in one column is have a description, I want to make a formula to look at that column for keywords which populates another column from a key.
so there is a solution, we can use IF function if the text contain "sharpertek" return as yes and if not so return as no but you have to add one more column and then by adding filter we can easily get that columns which contain "sharpertek" as yes.
Ok, and how do I write that function? I am trying to learn.
i am sending you a sample solution
