Find a range of text strings to return a text string.
Hi all, first post here so hope this makes sense...
...I need to return a text string in one cell, if one of a range of text strings is found in another cell.
So for example, if the word ‘reception’ or ‘office’ is found in one cell, I would like another cell to return ‘clean windows’. However, it should display nothing if ‘reception’ or ‘office’ are not found. In reality it will be a longer list of possible correct text strings.
I've managed this for one correct lookup but I can’t make it work for a range of possible correct lookups.
Thanks in advance
Pete
MacBook Air 13″, macOS 10.15