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

MATCH is a word that can be used in a variety of ways.

=MATCH(A1, "word1,"word2,"word3,"word4","word5", 0) returns the index of the corresponding item in the array list. The trailing 0 indicates that the match should be exact. If it isn't present, it will return #N/A, so you can add an IF(ISNA(to the front to make it behave like your "IN":

=IF(MATCH(A1, "word1,"word2,"word3,"word4","word5", 0),"NO","YES"), "NO","YES")
The order of the "YES" and "NO" has changed.