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

user_8255667 0
Viewed 823

Image of Google Sheet Data

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!

array-formulas google-sheets-formula google-sheets if-statement arrays
1 Answers

try:

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

0

user_56326290
Related