---
title: "Discussion on \"How to Fuzzy Match in Google Sheets (3 Ways)\" | Hashnode"
description: "Discussion on \"How to Fuzzy Match in Google Sheets (3 Ways)\". Google Sheets has no built-in fuzzy match. VLOOKUP, MATCH and XLOOKUP only find text that is identical, so \"Inytech\" will never find \"Initech\", and \"ACME Pty. Ltd\" will never find \"Acme Pty Ltd\". This"
url: "https://hashnode.com/posts/how-to-fuzzy-match-in-google-sheets-3-ways/6afe7d639b289b257b4f398e"
---

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

Discussion

# [How to Fuzzy Match in Google Sheets (3 Ways)](https://snakbacks.hashnode.dev/how-to-fuzzy-match-in-google-sheets-3-ways?utm_source=hashnode&utm_medium=feed)

Google Sheets has no built-in fuzzy match. VLOOKUP, MATCH and XLOOKUP only find text that is identical, so "Inytech" will never find "Initech", and "ACME Pty. Ltd" will never find "Acme Pty Ltd". This

6h ago · 6 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.
