Excel: If Cell Contains ONE of MANY THINGS

Описание: 👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
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
------------------------