If a match is detected, this will return the word, otherwise, it will return an error. The following is what I used for this example.
List of words to search for: G1:G7
Cell to search in A1
Enter as an array formula by pressing Ctrl+Shift+Enter.
This formula records the position of the word in the list as a positive value if it is found or as a negative value if it is not found by first searching the list of words for matches. The position of the discovered word in the list is represented by the greatest value in this array. A negative value is supplied to the INDEX() method and an error is raised if no word is found.
To return the row number of a matching word, you can use the following:
This also must be entered as an array formula by pressing Ctrl+Shift+Enter. It will return -1 if no match is found.