yogi_Find Row By Row If A Phrase In Column B Exists In Column A

Google Spreadsheet   Post  #2408

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-30-2018

question by: GioSico
https://productforums.google.com/forum/#!topic/docs/jX_Oql2okhg;context-place=forum/docs

Search string in Col A for words in Col B and paste found word in Col C
Hi Everyone,

I have been searching for a solution with no luck.  Any help is appreciated.

I have a long list of strings in Column A that have headings I want to extract, like Unit or School or Institute

The words I want to extract are in Column B

I want to past the extracted word in Column C

Both A and B can be a long list so manually typing and searching would be problematic.

My manual version does not use Column B and also fails to match "School" sometimes

"=IF(RegExMatch(A2,"School"),"School", IF(RegExMatch(A2,"Faculty"),"Faculty","Other") )"

Here is my sheet. Thanks in advance.

https://docs.google.com/spreadsheets/d/1GQLeXszsOVCC0AuQkC4L30EELEhsDkkbBoGHr26Xcf0/edit?usp=sharing