SEO Book PRO SEO Dashboard v0.0.16 Blank WordPress Login Rich Snippets

Google Spreadsheet Formula – INDEX|FILTER|REGEXMATCH

Article Details and Information
badge This article was written by SEO Book Pro | Published on 8:39 am, Fri, 26 August 22
SEO Book Pro Headline Feed rss_feed
Do you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.

SEO | Website Audit | WordPress SEO | SEO Audit Tools

↑ Grab this Headline Animator

Subscribe to Our Newsletter

Powered by FeedBurner

Enter your email address:

Delivered by FeedBurner

How to use the 3 Google Spreadsheet Formulas to find and Display Values that are Equal to our Goal Value in specific spreadsheet cell


In Short the Google Spreadsheet Formula combination with the following formulas:

  • INDEX
  • FILTER
  • REGEXMATCH

The Combination of these 3 Google Spreadsheet Formulas will search in specific Columns and Look for Columns Data to be Equal to the latest Cell from the formula E2 for example


For Example if you have 4 Columns with Data from Column A1 to Column D

The FILTER formula will look in All Columns and Rows from A1 to C20 for values in their Cells and Match the REGEXMATCH wich is our main Value to Search for and will Make MAtch equal to our Column E1 Value

If there is a Match from D1:D20 with our Goal in E1 the Related Row from Columns A1:D20 will be Displayed next to E1 and all the Values we are looking for

The Formula you can test and use for your Google Spreadsheet Tables and Needs


Get the formula below to test is with your Google Spreadsheet

=INDEX(FILTER($A$1:$C$20,REGEXMATCH($D$1:$D$20,$E1)))


26/08/2022 by SEO Book Pro
SEO Book Pro
5 stars
Technical SEO Audit
Quiet Valley Lane Sherman Oaks
Poway, CA 91403
8779 02354