yogi_From Paragraphs Of Information Submitted Via Google Form Determine Row By Row Whether A Task In Sheet Named Tasks Has Been Completed

                                          Google Spreadsheet   Post  #1409
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 03, 2013
question by aaron urban (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Sars_Mgkr1U)
find a specific string in a column and return "complete"

https://docs.google.com/spreadsheet/ccc?key=0AgudoyQwcsi9dGUxbG03LWhaQ3djb2hSVGxxcllwa2c&usp=drive_web#gid=0

I want the formula in Tasks!B:B to search the comma separated values in Complete!B:B for the value that exists in Tasks!C:C.

I can't quite wrap my head around it.  Any help would be greatly appreciated!

Thanks in advance!!

Aaron

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