This Excel video tutorial demonstrates how to check whether a cell contains one of many things or values. The solution uses the following functions:
SEARCH
ISNUMBER
SUMPRODUCT
This video will be useful to you if you are asking the following question:
How do you check if text is in a list in Excel?
If you are performing the following tasks it will also be useful:
Check if cell contains text from list and return value
Search for multiple text strings in cell
Check if cell equals one of multiple values
Search a cell for a list of words
------------------------