I'm looking for a way to search a word in a range
B2:G10 so it would return
yes if the word is in the range, or
no if isn't.
Ex: the formula searches in the ranges
B3 each with a different word (ex:
goodbye) and when the word
good is searched, it gives me
no, and if the word is
hello, it gives me
I've tried searching on this: Google Sheets formula for "if contains", but when I try the formulas, they are not working.