---
title: "Find all matching values in Google Sheets cells with Google Apps Script"
author: "Martin Hawksey"
date: 2023-01-24T21:12:18+00:00
modified: 2023-01-24T21:16:03+00:00
canonical_url: https://pulse.appsscript.info/p/2023/01/find-all-matching-values-in-google-sheets-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2023/01/find-all-matching-values-in-google-sheets-with-google-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "@LifeOfSpy"
  - "yagisanatode.com"
featured_image: https://pulse.appsscript.info/files/2023/01/find-values.jpg
description: "Handy little snippet from Scott Donald on using the Google Apps Script TextFinder class to find all the occurrences of matching text in a Google Sheet. The bit I particularly liked in this solution was how Scott used a .map method to return an object array of cell hits including A1 notation. Follow the source link for more information including a video tutorial."
---

# Find all matching values in Google Sheets cells with Google Apps Script

![Find all matching values in Google Sheets cells with Google Apps Script](https://pulse.appsscript.info/files/2023/01/find-values.jpg)

> Learn how to search and find all values in an entire Google Sheet spreadsheet, in a specific sheet tab or in a range with Apps Script.

Handy little snippet from Scott Donald on using the Google Apps Script `TextFinder` class to find all the occurrences of matching text in a Google Sheet. The bit I particularly liked in this solution was how Scott used a `.map` method to return an object array of cell hits including A1 notation:

![](https://pulse.appsscript.info/files/2023/01/Screenshot-2023-01-24-21.04.10-1.png)

Array containing an object for each sheet containing the sheet name and the cell location (Image credit: Scott Donald)

Follow the source link for more information including a video tutorial.

Source: *[Find All Values in Google Sheets with Apps Script – Yagisanatode*](https://yagisanatode.com/2023/01/24/find-all-values-in-google-sheets-with-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/01/find-all-matching-values-in-google-sheets-with-google-apps-script/](https://pulse.appsscript.info/p/2023/01/find-all-matching-values-in-google-sheets-with-google-apps-script/)*