Forum Discussion
Excel formula to find a string in column cells and output a value in column cells to the right.
Hi,
I have a solution for you, but it's supported by a complicated array formula!
Please find the attached file!
The problem is: you have an earlier version of Excel and earlier versions before Excel 2007 have many limitations and legacy functions, so I didn't find a solution easier than this!
Ah, that's a really neat solution, thanks Haytham Amairah!
Would it be possible to modify this slightly though?
Example:
I have cells in a column containing words like "petgroomers" and need the formula to find the string "groom" in that cell, and then return the "groomers" value to the cell on the right. (instead of looking for the exact words in the cell. I've been looking at the excel 'search' function, but not sure how to implement it, or even if it would be correct in this case?
Also, if the words "dog" AND "food" (two of the search terms) are found in the same cell, to return "dog" as default?
I have attached a file showing column A data, and the outputs that I need in column B.
Is this possible?
Many thanks for your expertise. I really appreciate it!
Chris.
Hi,
I have a solution for you, but it's supported by a complicated array formula!
Please find the attached file!
The problem is: you have an earlier version of Excel and earlier versions before Excel 2007 have many limitations and legacy functions, so I didn't find a solution easier than this!
Again, a really neat solution, thanks Haytham Amairah!
I have used the second formula in the most recent solution, and added "Bird" in the formula, and it also works perfectly!
As you suggested, I might start using a later version of excel, if it easier to work with?
You are a genius, my friend. Thanks!
Chris.