With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, December 2, 2014
yogi_Find The Words And The Starting Position(s) Of Words In Cell A2 That Occur In Cells A1 To J1
I don't want to share the spreadsheet because of the private information inside, but here is an example :
This lovely house will make you happy as it is perfect for your holidays.
the list of words are in the cells A1:J1
and the cell where I search these words is A2
In A3, I want to insert the function analyzing the content of A2 : if the function finds in A2's content at least 1 of the words from the A1:J1 list, I want it to give a value (whatever value : "yes/no" or "1/0" or the number of the 1st caracter where the listed word is found...)
In the above example, I'd like the function to find that A2 contains "holiday" which is in the A1:J1 list (F1).