Google Sheets

EXACT function in Google Sheets

Tests whether two strings are identical.

=EXACT(string1, string2)

EXACT syntax and parameters

Two arguments, two required.

string1stringRequired
string2stringRequired

EXACT examples

Formulas you'll actually reuse.

A case-sensitive comparison — “Lopez” vs “lopez” is FALSE:
```
=EXACT(A2, B2)
```
ResultFALSE
A case-sensitive count of a code (COUNTIF ignores case):
```
=SUMPRODUCT(--EXACT(A2:A200, "ABC-1"))
```
Result3

EXACT in Excel

Same name — your formula ports as-is.

Try EXACT in the playground

Edit the example — nothing to install.

Preloaded with the EXACT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.