I'm stuck trying to create a formula searching a range on a row to find specific text. The problem I have is the text string could be found in other cells that I need to ignore.
For example (attached) I want to search for the word "Communication" in the range A:H and return the value in the column to the right. But not where the word "Info" appears. So in my example I want to find the string "Communication" only, but "Information and Communication" also contains the same word, but I want it to ignore cells that have the string "Information" in it.
Can this be done?
Bookmarks