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.
48 Replies
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
- Try with vert.search or something like this, I'm sorry but I use the italian version where we have cerca.vert. Lorenzo
- Could you post a sample file please
Attached is my file.
- Sorry, I ,meant an example of what you are trying to do
So a simple version with a brief description of what you are trying to do
Thanks
