yogi_Mark 'X' In Corresponding Row of Column C If A String In Cells of Column A Appears In A Cell of Column B

                                         Google Spreadsheet   Post  #1625
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-06-2014
post by: Casandra Espinoza (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/9a3d5U3EzYU)
Matching a String in a Cell Against an Entire Column

My goal is to check if a string in the first column, appears somewhere in another column. I want it to be a match if any of the following properties hold:

1. Strings match exactly
2. Strings match regardless of case-sensitivity 
3. Strings match even if only partial

I have created an example to better illustrate my question: https://docs.google.com/spreadsheets/d/1lyGKdR7g8yx2tK4bKGRoxN7AZqsjSq6tbAO0wkpd2hU/edit?usp=sharing 

I would appreciate any help here!

Thank you!

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