How to use match function in Excel (Exact)

Purpose: 
This function compares two text strings and results in TRUE and FALSE. The function matches 2 strings from 2 cells or 2 fixed values.

Return value: 
A boolean value (TRUE or FALSE)

Syntax: 
Use below syntax in any of the excel sheet cell to compare 2 strings.
=EXACT(text1, text2)

Examples:

Below are two examples of the EXACT function used with fixed strings. In the first example, the strings are identical, in the second example, only difference is the uppercase “A”: =EXACT("apple","apple") // returns TRUE
=EXACT("Apple","apple") // returns FALSE  
In the example shown, the formula in D6, copied down the column, is:

  You can also use a normal equals sign (=) in a formula, but the comparison is not case sensitive:
=("Apple"="apple") // returns TRUE  
To count cells that contain specific text, taking into account upper and lower case characters, you can combine EXACT together with the SUMPRODUCT function like this:

Excel match allows the wildcard matching of strings. Exact function does the strict matching on strings.

Thanks for reading.