Exact

Syntax

Exact(Text1, Text2)

Text1. The first string.

Text2. The second string.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It returns whether two text strings are exactly the same.

The check is case-sensitive. It returns TRUE if strings are exactly the same, and FALSE - if otherwise.

Formula	Result	Description
=Exact("Ac", "ac")	FALSE	It checks if the "Ac" and "ac" strings match each other (case-sensitive).
=Exact(B6, C6)	TRUE	It checks if strings in the B6 and C6 cells match each other. The B6 cell contains the bc value, the C6 cell contains the bc value.