---
title: "The Gift of Script: Search spreadsheet for multiple criteria"
author: "Phil Bainbridge"
date: 2020-10-27T15:31:34+00:00
modified: 2020-10-27T16:06:34+00:00
canonical_url: https://pulse.appsscript.info/p/2020/10/the-gift-of-script-search-spreadsheet-for-multiple-criteria/
markdown_url: https://pulse.appsscript.info/p/2020/10/the-gift-of-script-search-spreadsheet-for-multiple-criteria.md
categories:
  - "Beginner"
  - "Sheets"
  - "Snippet"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2020/10/Searchspreadsheetformultiplecriteria.png
description: "Search through rows of a Google Sheet simultaneously looking for certain criteria all in one single loop. I needed a way of doing this without multiple loops despite searching for separate information and here is..."
---

# The Gift of Script: Search spreadsheet for multiple criteria

![The Gift of Script: Search spreadsheet for multiple criteria](https://pulse.appsscript.info/files/2020/10/Searchspreadsheetformultiplecriteria.png)

> Search through rows of a Google Sheet simultaneously looking for certain criteria all in one single loop. I needed a way of doing this without multiple loops despite searching for separate information and here is a way of achieving that via true/false flags.
> [https://www.pbainbridge.co.uk/2020/10/search-spreadsheet-for-multiple-criteria.html](https://www.pbainbridge.co.uk/2020/10/search-spreadsheet-for-multiple-criteria.html)Screenshot of spreadsheet data to search

Source: *[The Gift of Script: Search spreadsheet for multiple criteria*](https://www.pbainbridge.co.uk/2020/10/search-spreadsheet-for-multiple-criteria.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/10/the-gift-of-script-search-spreadsheet-for-multiple-criteria/](https://pulse.appsscript.info/p/2020/10/the-gift-of-script-search-spreadsheet-for-multiple-criteria/)*