Check if a cell contains text (case-insensitive) in Excel
Learn how to find text inside cells, when the case of the text doesn't particularly matter.
Check if a cell contains text (case-sensitive) - Microsoft Support
Learn how to check if a cell contains text, when the case of the text is important.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
MATCH function - Microsoft Support
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
FIND function - Microsoft Support
This article describes the formula syntax and usage of the FIND function in Microsoft Excel. FIND locates one text string within a second text string, and return the number of the starting position of …
Use Excel built-in functions to find data in a table or a range of ...
This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. This article uses …
Use the COUNTIF function in Microsoft Excel
In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: The group of cells you want to count. Range can contain numbers, arrays, a …
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The third argument is the column in that range of cells that contains the value that you seek. The fourth argument is optional. Enter either TRUE or FALSE. If you enter TRUE, or leave the argument blank, …
Count how often a value occurs in Excel - Microsoft Support
Count how often a value occurs in Excel. Suppose you want to find out how many times particular text or a number value occurs in a range of cells. For example: If a range, such as A2:D20, contains the …
Check if a cell contains text (case-insensitive) in Excel
Learn how to find text inside cells, when the case of the text doesn't particularly matter.
Ways to count cells in a range of data in Excel
Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. Select the cell where you want the result to appear.