Google Spreadsheet Formula – INDEX|FILTER|REGEXMATCH

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)))