How to use an IF statement to compare value against array in Google Sheets

Question

In cell A4, I have a value, lets say clt. In A5 I have the following formula:

=if(A4 = {A$1:$C$3}, 0, "Yes!")

Clearly, it's not working but I hope you can appreciate the logic I am attempting. Also, this is a quick representation of my example as the actual dataset is confidential.

Any direction is appreciated!

Answer 1

You can accomplish this via a COUNTIF function

=IF(COUNTIF(A1:C3,A3)>0,"Yes!")

Answer 2

try:

=ARRAYFORMULA(IF(A4=A1:C3, 0, "Yes!"))