Friday, March 18, 2016

yogi_Find Associated Category Based On KeyWord For Given Categories Sentences And KeyWords

Google Spreadsheet   Post  #2053
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-18-2016
post by: Raivis:!topic/docs/HsAe02WPZqs;context-place=forum/docs

Array formula that checks for specific string


It should be simple: array formula + vlookup + regex, but I am struggling with it. Please see this spreadsheet.

Column A is the category, B is a column that holds sentences. C is the keyword column. I am trying to come up with an array formula that would look for keywords in Sentences and return Category. You can see that my approach is not working. The column E shows the values that I expect to see. Could you please help me?