Hello. Would anyone be able to help me with a formula that returns a result based on the first word of a cell? I have a formula set up to return results based on five words should they appear in said cell, however, it returns results according to the order my formula lists the the words being searched for. I need it to return results based on the first word of the cell it is searching in. Thanks in advance.![]()
Bookmarks