Search for specific info in a block of cells

[mattjpep]

I have the follow block of data in cells A10:G16. I need a formula to search for the value 4 in this block of cells. If 4 is found then return YES, if not then return NO.

	A	B	C	D	E	F	G
10	S	M	T	W	T	F	S
11							1
12	2	X	4	X	X	X	8
13	9	X	X	X	X	X	15
14	16	X	X	X	X	X	22
15	23	X	X	X	X	X	29
16	30	X

<tbody>
</tbody>

DOO​

 

[Jonmo1]

Try

=IF(COUNTIF(A11:G16,4), "Yes", "No")

 

[mattjpep]

Perfect! Thank you for the help. I had a feeling it was something simple, but wasn't thinking about COUNTIF. I appreciate it!

 

[Jonmo1]

You're welcome.