Test if a cell has specific text in an array

Hello

I cannot find the answer on google because I am not able to google properly.

Basically, I need a formula to return a 1 or 0 if a cell has text matching any of a few conditions. I am using an array in an IF function to hold the text I want to check for.

It only works if the text in the cell matches the text that is first in the array, ie, if the array returns {1,0,0,0,0}, but I need it to work if ANY of the array results are true. Sample spreadsheet attached.

=@IF(A1={"A-X","A-L","A-N","GS/A-N"},1,0) is the formula. It only returns a 1 when A1= A-X. It is frustrating.

Thanks!

Hi to both!

Another options:
=IF(OR(A1={"A-X","A-L","A-N","GS/A-N"}),1,0)
=--OR(A1={"A-X","A-L","A-N","GS/A-N"})

Blessings!

Thanks guys for your responses!

Both of those work!

I found a slight less calculative intensive formula as well:

=If(sum(countif(a1,{"*A-L","*A-N","*A-X"}))>0,1,0)