---
title: "#spreadsheets articles | Hashnode"
description: "Explore 196 articles tagged #spreadsheets on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/spreadsheets"
---

Tag

# #spreadsheets

196 posts · 12 followers

[Snakbacks](https://hashnode.com/@snakbacks) · [6h ago](https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f)

### [Match Names with Typos in Google Sheets (Fuzzy Name Matching)](https://snakbacks.hashnode.dev/match-names-with-typos-in-google-sheets-fuzzy-name-matching?utm_source=hashnode&utm_medium=feed)

Names that should match but do not are a daily Sheets problem: "Smith, John" against "John Smith", "Jon" against "John", "Dr. J. Smith" against "John Smith". Standard lookups need an exact match. This

5 min read · [snakbacks.hashnode.dev](https://snakbacks.hashnode.dev/match-names-with-typos-in-google-sheets-fuzzy-name-matching?utm_source=hashnode&utm_medium=feed)

[2](https://hashnode.com/posts/match-names-with-typos-in-google-sheets-fuzzy-name-matching/6afe7e13639e0ff3b768f04f)

[Snakbacks](https://hashnode.com/@snakbacks) · [6h ago](https://hashnode.com/posts/how-to-fuzzy-match-in-google-sheets-3-ways/6afe7d639b289b257b4f398e)

### [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

6 min read · [snakbacks.hashnode.dev](https://snakbacks.hashnode.dev/how-to-fuzzy-match-in-google-sheets-3-ways?utm_source=hashnode&utm_medium=feed)

[Snakbacks](https://hashnode.com/@snakbacks) · [6h ago](https://hashnode.com/posts/compare-two-sheets-in-google-sheets-find-differences/6afe7dbe9b289b257b502318)

### [Compare Two Sheets in Google Sheets (Find Differences)](https://snakbacks.hashnode.dev/compare-two-sheets-in-google-sheets-find-differences?utm_source=hashnode&utm_medium=feed)

To compare two sheets in Google Sheets you have two different jobs. One is a cell-by-cell comparison of two tabs with the same layout. The other is matching rows by a key, to find rows in Sheet1 that

5 min read · [snakbacks.hashnode.dev](https://snakbacks.hashnode.dev/compare-two-sheets-in-google-sheets-find-differences?utm_source=hashnode&utm_medium=feed)

[SheetError](https://hashnode.com/@sheeterror) · [3d ago](https://hashnode.com/posts/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name/6afa8f49ec731951ec7b7206)

### [#NAME? "Unknown function" in Google Sheets: fix the misspelled function name](https://sheeterror.hashnode.dev/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name?utm_source=hashnode&utm_medium=feed)

You type what looks like a normal VLOOKUP and the cell shows #NAME?. The tooltip says Unknown function: ‘VLOKUP’. The ranges are fine. The formula never ran. Sheets doesn't recognize the name. Why it

3 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/name-unknown-function-in-google-sheets-fix-the-misspelled-function-name?utm_source=hashnode&utm_medium=feed)

[SheetError](https://hashnode.com/@sheeterror) · [Nov 12](https://hashnode.com/posts/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first/6af530c2c6ace04af82917bf)

### [FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first](https://sheeterror.hashnode.dev/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first?utm_source=hashnode&utm_medium=feed)

\=FILTER(...) comes back as #N/A. The key you wanted might be missing, or it might be sitting right there. Both look like #N/A. The tooltip is what tells them apart. Why it happens FILTER uses #N/A for

3 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/filter-no-matches-are-found-n-a-in-google-sheets-two-causes-read-the-tooltip-first?utm_source=hashnode&utm_medium=feed)

[Erudience LTD](https://hashnode.com/@erudience-ltd) · [Nov 11](https://hashnode.com/posts/free-excel-spreadsheet-auditor-find-hidden-errors-in-seconds/6af3c001d2aea034ab47904e)

### [Free Excel Spreadsheet Auditor: Find Hidden Errors in Seconds](https://excelerrorfinder.hashnode.dev/free-excel-spreadsheet-auditor-find-hidden-errors-in-seconds?utm_source=hashnode&utm_medium=feed)

A workbook can look perfect and still be wrong. Here is how to find the errors no one sees — in under a minute, for free, without uploading your file.

7 min read · [excelerrorfinder.hashnode.dev](https://excelerrorfinder.hashnode.dev/free-excel-spreadsheet-auditor-find-hidden-errors-in-seconds?utm_source=hashnode&utm_medium=feed)

[SheetError](https://hashnode.com/@sheeterror) · [Nov 10](https://hashnode.com/posts/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip/6af27b689f97831e0a141277)

### [IMPORTRANGE #REF! "You need to connect these sheets" in Google Sheets: click Allow access, then read the tooltip](https://sheeterror.hashnode.dev/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip?utm_source=hashnode&utm_medium=feed)

You write =IMPORTRANGE(...) to pull a range from another spreadsheet and the cell shows #REF!. The URL is right, the range is right, and the tab exists. Hover the cell and the tooltip says You need to

3 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/importrange-ref-you-need-to-connect-these-sheets-in-google-sheets-click-allow-access-then-read-the-tooltip?utm_source=hashnode&utm_medium=feed)

[Richard C](https://hashnode.com/@ailstudio) · [Nov 9](https://hashnode.com/posts/did-that-cancellation-actually-work-a-cancellation-check-log-in-google-sheets/6af239c72c58937f358afefb)

### [Did that cancellation actually work? A cancellation check log in Google Sheets](https://ailstudio.hashnode.dev/did-that-cancellation-actually-work-a-cancellation-check-log-in-google-sheets?utm_source=hashnode&utm_medium=feed)

After cancelling a subscription, log its expected next charge date and check your statement. This spreadsheet does not cancel services or send alerts.

7 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/did-that-cancellation-actually-work-a-cancellation-check-log-in-google-sheets?utm_source=hashnode&utm_medium=feed)

[SheetError](https://hashnode.com/@sheeterror) · [Nov 7](https://hashnode.com/posts/formula-parse-error-in-google-sheets-after-pasting-a-formula-commas-vs-semicolons/6aeeb478b56e59a22891fc90)

### [Formula parse error in Google Sheets after pasting a formula: commas vs semicolons](https://sheeterror.hashnode.dev/formula-parse-error-in-google-sheets-after-pasting-a-formula-commas-vs-semicolons?utm_source=hashnode&utm_medium=feed)

You paste a VLOOKUP from a tutorial and the cell shows #ERROR!. The tooltip says Formula parse error. The function name is spelled right. The problem is the commas. Why it happens The argument separat

2 min read · [sheeterror.hashnode.dev](https://sheeterror.hashnode.dev/formula-parse-error-in-google-sheets-after-pasting-a-formula-commas-vs-semicolons?utm_source=hashnode&utm_medium=feed)

[Richard C](https://hashnode.com/@ailstudio) · [Nov 6](https://hashnode.com/posts/how-to-find-duplicate-records-after-a-salesforce-data-migration-before-users-do/6aede1b9d24a82b8dae79555)

### [How to find duplicate records after a Salesforce data migration (before users do)](https://ailstudio.hashnode.dev/how-to-find-duplicate-records-after-a-salesforce-data-migration-before-users-do?utm_source=hashnode&utm_medium=feed)

By Richard C, AIL Studio The load finished, the record counts are close enough, and sign-off is tomorrow. Then a sales rep finds "Northwind Traders" twice, with Contacts split between the two. Here's

5 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/how-to-find-duplicate-records-after-a-salesforce-data-migration-before-users-do?utm_source=hashnode&utm_medium=feed)
