Using SQL “IN” Function in Excel

Question

Is there an "IN" type function like the one used in sql that can be used in excel? For example, if i am writing an If statement in excel and I want it to check the contents of a cell for 5 different words can i write something like:

=If(A1=IN("word1","word2","word3","word4","word5"),"YES","NO")

Answer 1

=IF(OR(A1={"word1","word2","word3","word4","word5"}),"YES","NO")

Answer 2

You could use MATCH :

=MATCH(A1, {"word1","word2","word3","word4","word5"}, 0) 

which will return the index of the matching item in the array list. The trailing 0 means it should be an exact match. It will return #N/A if it isn't there, so you can tag a IF(ISNA( onto the front to make it behave like your "IN":

=IF(ISNA(MATCH(A1, {"word1","word2","word3","word4","word5"}, 0)),"NO","YES")

Note the change in order of the "YES" and "NO"