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     www.energyefficientbuild.com.   Mar-18-2016

post by: Raivis:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/HsAe02WPZqs;context-place=forum/docs

Array formula that checks for specific string

 

Hi,

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?

---------------------------------------------------------------------------------