Zoho Sheet EXACT Function: Syntax, Examples and Troubleshooting

=EXACT(text1; text2)

Zoho explicitly documents case sensitivity. The function returns Boolean TRUE only when the text strings match; otherwise FALSE. Zoho’s Help uses a semicolon (;) between the two arguments. Double quotation marks delimit literal strings. Do not confuse the ; with the punctuation appearing inside text.

For repeatable examples, create a new, empty Zoho Sheet and paste or import the companion CSV batches/zoho-sheet/2026-10-11T0745Z-text-case-clean-batch08/zoho-text-clean-case-practice.csv beginning at A1. Its first row is the header; rows 2 through 9 contain the fictitious records below. Keep identifier columns C and D formatted as text so values such as ca-0041 retain their zeros and hyphen. Compare the imported cells to the table before calculating; an import tool can change apparent values.

Use empty cells starting in F2 for demonstration formulas. Do not paste output formulas on top of source columns A:D. All expected results refer to the listed source data, not a live or connected customer database.

1. In the companion table, A2 contains eAST DEPOT; B2 contains East Depot.
2. In empty F2 enter =EXACT(A2;B2).
3. Expected F2: FALSE, because the case differs.
4. In another empty cell enter =EXACT(A9;B9) for the row where both values are North Hub.
5. Expected: TRUE. Both text strings are identical in the sample.
6. Test two direct literals to isolate cell-import issues.

The expected Booleans were independently calculated using exact Python string comparisons for this printable ASCII dataset; they were not read from Zoho’s runtime.

Advanced: show both raw and normalized match status

In F2:

=EXACT(C2;D2)

Expected F2: FALSE for ca-0041 versus CA-0041.

In G2:

=IF(EXACT(UPPER(C2);D2);"MATCH";"REVIEW")

Expected G2: MATCH, because uppercasing the left code makes it identical to the right code. These are different questions: one asks whether the original strings are exactly equal, and the other asks whether their uppercase forms agree.

Keep both flags if input case has business significance. A normalized match does not show that the raw values were identical, and case normalization can collapse formerly distinct codes.

• Case-sensitive: Zoho and zoho do not match. This is directly established by Zoho’s examples.
• Spaces count as characters: North Hub and North Hub differ; ensure trailing whitespace is intentional.
• Styling is not text: Cell colours and fonts are not content comparisons. Do not use EXACT to detect formatting-only differences.
• Canonicalization before comparison: UPPER, LOWER, TRIM and CLEAN solve different data issues; applying one changes the question EXACT is answering.
• Wrong references: Compare actual values in the intended cells; a copied formula can silently shift one reference.
• Non-ASCII/normalization: Visually identical Unicode strings may differ at code-point level; the Zoho Help page does not document Unicode normalization. A native check is needed.
• Not a membership test: EXACT compares two supplied inputs; it does not look up a code in an authoritative data source.

Universal troubleshooting checklist

1. Check that the intended cell is text, not a date, number or imported value reinterpreted by the editor.
2. Confirm that the function name is spelled correctly and that text literals use straight double quotation marks.
3. Recheck the cell address and the contents of the specific input row; copying a formula downward changes relative references.
4. If a formula unexpectedly shows #NAME!, inspect the function spelling and quoted literals. A #REF! may indicate an invalid or removed reference; #VALUE! is a common argument-type warning. Zoho’s generic error table does not establish that each sample here produces these errors.
5. When a nested formula fails, calculate each inner expression in its own helper cell and compare with the stated expected result before combining the functions.
6. If behaviour differs from these documentation-derived expectations, capture the Zoho Sheet environment, account locale, formula and actual displayed result for editorial review; do not quietly replace documentation claims with guesses.

Microsoft Excel’s EXACT documentation confirms case-sensitive text comparison and also says formatting differences are ignored. This supports a similar concept, not guaranteed parity for Unicode normalization or coercion. Zoho’s help writes EXACT(text1; text2) using semicolons, while Excel’s English syntax displays EXACT(text1, text2) using commas (settings may alter separators). Use the destination parser’s syntax after migrating a formula.

• UPPER
• LOWER
• PROPER
• CLEAN
• TRIM

Official and external references (retrieved October 11, 2026):

• Zoho Sheet: EXACT function.
• Zoho Sheet: official Text function category.
• Microsoft alternative: EXACT or related text documentation.

• Zoho Sheet — function documentation
• official Text function category

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.