Return every match
=FILTER(B2:B,EXACT(E2,A2:A))Returns all rows with exactly the same case.
PASTE-READY RECIPE
Case-Sensitive Lookup in Google Sheets
Match IDs that differ only by uppercase and lowercase letters.
QUICK ANSWER
The formula and where it fits.
Match IDs that differ only by uppercase and lowercase letters. Use =INDEX(B2:B,MATCH(TRUE,EXACT(E2,A2:A),0)), then replace the sample ranges with the columns in your sheet.
EXACT creates a case-sensitive TRUE/FALSE array for MATCH.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | B | |
|---|---|---|
| 1 | Code | Owner |
| 2 | ||
| 3 | ||
| 4 |
FORMULA OUTPUTLeoRecalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Case-sensitive count
=SUM(N(EXACT(E2,A2:A)))Counts exact-case matches.
Readable fallback
=IFNA(INDEX(B2:B,MATCH(TRUE,EXACT(E2,A2:A),0)),"Not found")Replaces #N/A.
COMMON ERRORS
When the result looks wrong.
A normal lookup ignores case
Use EXACT inside MATCH or FILTER.
Array evaluation is missing
Use the formula as written; modern Google Sheets handles the array automatically.
QUESTIONS
Answers before you paste.
A normal lookup ignores case
Use EXACT inside MATCH or FILTER.
Array evaluation is missing
Use the formula as written; modern Google Sheets handles the array automatically.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.