---
title: "Discussion on \"Case-Sensitive and Case-Insensitive Match in Google Sheets\" | Hashnode"
description: "Discussion on \"Case-Sensitive and Case-Insensitive Match in Google Sheets\". Most lookups in Google Sheets ignore capital letters, which is usually helpful and sometimes a problem. If \"abc\" and \"ABC\" are different codes, VLOOKUP will quietly return the wrong one. This page lis"
url: "https://hashnode.com/posts/case-sensitive-and-case-insensitive-match-in-google-sheets/6b00e7601b9f435532abd090"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Case-Sensitive and Case-Insensitive Match in Google Sheets](https://snakbacks.hashnode.dev/case-sensitive-and-case-insensitive-match-in-google-sheets?utm_source=hashnode&utm_medium=feed)

Most lookups in Google Sheets ignore capital letters, which is usually helpful and sometimes a problem. If "abc" and "ABC" are different codes, VLOOKUP will quietly return the wrong one. This page lis

16h ago · 4 min read · snakbacks.hashnode.dev  
Read the article

-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)

## Written by

[Snakbacks](https://hashnode.com/@snakbacks)

@snakbacks

  
[View profile](https://hashnode.com/@snakbacks)

Google Sheets how-tos: fuzzy matching, duplicates and lookups. Tested formulas you can copy.

Snakbacks builds small, fast Google Sheets tools and writes tested how-to guides at https://www.snakbacks.com

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
