Good afternoon all,
I am hoping one of you helpful users will be able to help me with the attached.
Basically i am trying to write a formula with either find or search to identify if a text string in a cell is in a column. i have a list of works activities previously forecast to be completed in the month (in column B) and a list of the actual works activities completed in the month (in column E.) i want the formula in column C to look for the works activity in column B and identify if it is in column E also.
So the formula in the attached in Cell C5 will look for the works activity in cell B5 in cells E5 to E17.
Ideally if it could make the item in cell B5 a wildcard, that would be ideal as you will notice in the attached cell B6 "Ferric Dosing +POA's" has been completed in the month (as it is in column E) however in column E this is just identified as "Ferric Dosing". If this is not possible however, it is not the end of the world as i appreciate that will likely make the formula much more complex and i don't want to go down the route of VBA.
If anyone could have a look and come up with a solution, it would be greatly appreciated!
Many kind regards
Andrew
Bookmarks