Tuesday, May 6, 2014

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!
------------------------------------------------------------------------------------------------------------------------------------------------