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
------------------------
Excel: If Cell Contains ONE of MANY THINGS
Теги
excel check if cell contains text from list and return valueexcel search for multiple text strings in cellexcel check if cell contains text from list and return text=if(isnumber(search( for multiple cellsexcel search a cell for a list of wordsif cell equals one of multiple valuesif cell contains one of many things
