EXACT
returns TRUE if two text strings are identical
Syntax:
EXACT(text1, text2)
returns TRUE if the text strings text1 and text2 are exactly the same (including case).
Example:
EXACT("red car", "red car")
returns TRUE.
EXACT("red car", "Red Car")
returns FALSE.
Application:
Let's say a company has two systems: an old inventory system and a new one. They want to migrate all product data from the old system to the new one. A critical step is to verify that the product IDs have been entered correctly and match exactly in both systems. Any discrepancy, even a difference in capitalization, could cause significant problems later.
Here's how the EXACT function can be used:
Product ID (Old System) | Product ID (New System) | Exact Match? | ||
|---|---|---|---|---|
A | B | C | ||
1 | PROD-101 | PROD-101 | TRUE | |
2 | prod-102 | PROD-102 | FALSE | |
3 | PROD-103 | PROD-103 | TRUE | |
4 | PROD-104 | PROD-104 | TRUE | |
5 | PROD-105 | PROD-105a | FALSE |
In a spreadsheet, you would use the following formula in the "Exact Match?" column:
EXACT(A2, B2)
- For the first row, EXACT("PROD-101", "PROD-101") returns TRUE. The strings are identical.
- For the second row, EXACT("prod-102", "PROD-102") returns FALSE. The strings are not identical because of the difference in capitalization.
- For the third row, EXACT("PROD-103", "PROD-103") returns TRUE.
- For the fourth row, EXACT("PROD-104", "PROD-104") returns TRUE.
- For the fifth row, EXACT("PROD-105", "PROD-105a") returns FALSE. There is an extra character in the second string.
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof