Hello,
I know this is probably relatively simple, but I am trying to figure out how to construct a formula that checks to see if a cell contains any of the words from a list, and if so, returns the word to the immediate right of the identified word. So for example:
Thank you!
I know this is probably relatively simple, but I am trying to figure out how to construct a formula that checks to see if a cell contains any of the words from a list, and if so, returns the word to the immediate right of the identified word. So for example:
Text | Returned: | List | |||
Hello my name is tom | my | Hello | |||
It is nice to get to know you tom | to | Nice | |||
Good to meet you, tom | you | Meet |
Thank you!