Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I have a column with descriptions within cells.
I would like to identify where the description includes specific words - e.g. does cell contain and of the following words:
Tom, Dick or Harry
I have used = ISNUMBER(search("Tom", A2)) but that would only return where Tom exists. What do I need to do to return where cell contains either of Tom, Dick or Harry?
Thanks!
=ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH({"tom","dick","harry"},A2)),0))
Maybe useful to know that using "Mid" on the difference between your number and a "Find" (starting from your number) on the next occurrence of SPACE will pull those found words out for you.
But thats probably where you are going with this anyway