How Google Sheets Lookups Handle Capital Letters, and How to Control It
Many Google Sheets functions ignore capitalisation, which can cause VLOOKUP to return the wrong result when codes differ only by case. Functions such as VLOOKUP, MATCH, COUNTIF, and SUMIF are case-insensitive, while EXACT, FIND, and REGEXMATCH (by default) respect case. The guide shows how to force exact-case matching using EXACT with INDEX/MATCH or FILTER, and how to count repeats case-sensitively with SUMPRODUCT. It also notes that UNIQUE is case-sensitive, so case-insensitive behaviour must be forced with LOWER, and that trailing or extra spaces break matches in both modes.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in