What LOWER does
LOWER converts every uppercase letter in a text string to lowercase. It is a simple but useful normalization step before lookups, comparisons, or text matching.
Practical examples
Convert a cell value to lowercase
=LOWER(A2)
Use this when source text arrives in mixed case and you want a consistent lowercase version.
Normalize a lookup value inside VLOOKUP
=VLOOKUP(LOWER(A2),Table_Array,2,FALSE)
This helps when the lookup process depends on consistent letter case.
Common mistakes and notes
LOWER changes letters only
Numbers, punctuation, and other non-letter characters stay exactly as they are.
LOWER does not fix spacing problems
If the match still fails, hidden spaces may be the real issue and TRIM may be the better cleanup step.