def search_func(row):
    matches = [(test_value in row['Description'].lower()) for test_value in
        row['Text_Search']]
if any(matches):
    return 'Yes'
else:
    return 'No'
Python/Pandas: How to Match List of Strings with a DataFrame column