Google Sheets EXACT Function: Syntax, Examples & Tips

string1:
The first string that you want to compare. This can be a text string, a cell reference, or a formula that returns a string.

string2:
The second string that you want to compare against the first string. This can also be a text string, a cell reference, or a formula that returns a string.

What is an EXACT Function?

The EXACT function in Google Sheets is a useful tool that checks whether two text strings are exactly the same. It is case-sensitive, meaning that it distinguishes between uppercase and lowercase letters. This function is particularly helpful when you need to ensure that data entries match precisely, such as when validating user input or comparing lists.

In simpler terms, the EXACT function allows you to compare two pieces of text and determine if they are identical.

A Practical Example

Imagine you are managing a list of usernames for a website and you want to verify if the entered username matches the existing usernames in your database.

Usernames Table:

Input Table:

You want to check if the usernames entered in the Input Table match the usernames in the Usernames Table.

EXACT Formula

To achieve this, you would use the EXACT function as follows:

=EXACT(A2, Usernames!A:A)

In this formula:

• A2 is the cell containing the InputUsername you want to compare.
• Usernames!A:A is the range where the function will look for matching usernames in the Usernames Table.

Result of the Formula

When you apply the EXACT formula to the Input Table, the output would look like this:

In this case, the first username matches exactly (case-sensitive), while the second one does not match due to the difference in capitalization.

Why Use EXACT?

EXACT is beneficial because it provides a straightforward way to compare text strings with precision. It is particularly useful in scenarios where case sensitivity matters, such as password validation or ensuring data integrity. By using the EXACT function, you can easily identify discrepancies in data entries.

Key Takeaways:

• EXACT: A function that checks if two text strings are exactly the same, considering case sensitivity.
• Precision: Ideal for scenarios where exact matches are required, such as username or password validation.
• Data Integrity: Helps maintain accurate data by identifying mismatches in text entries.

The EXACT function is an essential tool for anyone working with text data in Google Sheets, providing a reliable way to ensure data accuracy and consistency.

Happy spreadsheeting!