yogi_For Words In Column C Compute Row By Row Category Based On Specs In 'Words to look for'

Google Spreadsheet   Post  #2566

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-03-2019

question by: DanielF:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/YFvMMiVY-1g;context-place=mydiscussions
Finding one word out of a range of words in a text cell.

Hello guys,

I am looking for a way to search for a range of words in a text cell and then give the given category of the word which was found (so 1.1,1.2 etc.). If no word is found in the text cells then nothing should be shown. The words I am looking for and the categories are shown in the attachments. These are just some examples and the categories are going to be large (100+).

Thanks in advance!

Daniel

Table.jpg

7 KB