search in multiple columns if a specific value exists

[psdileep]

I've data in 47000 rows and 20 columns. I've hidden all columns except two from which I need to do analysis.

I need to search in these two columns and identify if a particular string exists in either of the columns and return 'yes' or 'no'.

From the below example, I want to search for "Apple" in Col 1 and Col 2 and in Col 3, I should have row 2 and row 4 are marked as yes (for that matter some remark which says yes). Because 'Apple" can be found in row 2 and row 4.

Any formula or function I can use?

Col 1	Col2
Apple is red <tbody> </tbody>	I like mangoes <tbody> </tbody>
Orange is orange <tbody> </tbody>	I am a boy <tbody> </tbody>
mango is yellow <tbody> </tbody>	I like apples <tbody> </tbody>
grapes are purple <tbody> </tbody>	I don’t know <tbody> </tbody>

<tbody>
</tbody>

 

[jtakw]

Well, there are flaws with that formula, it'll incorrectly count "pineapple", "applecider" or "apple-cider", "applepie", etc.