Excel like a finance pro.
EXACT
Text & cleanupExcel's = ignores case. A reconciliation that treats INV-1 and inv-1 as the same can be quietly wrong.
Difficulty
1What is it?
=A2=B2 returns TRUE for "INV-1" and "inv-1", because Excel's comparison ignores case — and so do VLOOKUP, XLOOKUP, MATCH and COUNTIF. Most of the time that's what you want. It isn't when the codes come from a system that treats them as different records, when you're reconciling two lists and need to know they match character for character, or when a customer ID is case-sensitive. EXACT compares two strings exactly: case, spacing and all. It's also the quickest way to find out why two cells that "look identical" won't match — if EXACT says FALSE, something invisible differs.
2What it looks like
EXACT(text1, text2)- text1, text2
- The two values to compare. Numbers are compared as text, so 1 and 1.0 are FALSE.
3When you use it
- Reconcile two lists of case-sensitive codes.
- Find out why two apparently identical cells won't match.
- Build a case-sensitive lookup with XMATCH or INDEX.
4See it in action
Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.
Two codes that look the same. Change the second one.
=EXACT(A2, B2)=A2=B2 → TRUE| A | |
|---|---|
| 1 | Result |
| 2 | =A2=B2 → TRUE |
| 3 | =EXACT(A2, B2) → FALSE |
| 4 | LEN: 8 vs 8 |
| 5 | What differs: letter case. If EXACT says FALSE, something invisible is there. |
The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.
5Common errors
FALSE for cells that look the sameAn invisible difference: a trailing space, a non-breaking space from a web copy, a different dash.Fix: That's EXACT doing its job. Compare LEN of both cells to find the extra character, then CLEAN and TRIM.
Lookups still match the wrong caseXLOOKUP and MATCH ignore case even when you care.Fix: Build the case-sensitive lookup: XMATCH(TRUE, EXACT(range, value)).
Numbers compare FALSEEXACT compares as text, so 1 and 1.00 differ.Fix: Use = for numbers. EXACT is for text.
6Better functions & alternatives
- =A2=B2 — Case-insensitive, which is right most of the time. EXACT is for when case is part of the identity.
- TRIM / CLEAN — Fix the invisible characters EXACT finds, then most comparisons stop failing.
Want EXACT already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.