Google Sheets INDEX | Use INDEX Google Sheets to Extract Data | Google Sheets Function

Use Google Sheets INDEX to get data from the cell, which intersects with the specified row and column. For example, if you wish to extract data from the cell at the intersection of row 5 and column 3, then the Google Sheets INDEX can do this job.

Let's look at the format of the INDEX Google Sheets:

=INDEX(reference, [row], [column])

INDEX is the name of the function reference, or range, is the area that contains the data you wish to extract row is a number, which the function should offset down. The row attribute is optional.
column is a number, which the function should offset across. The column attribute is optional.

For the example above, if the range is from cell A2 to cell D6, the Google Sheets Index function will be:

=INDEX(A2:D6, 5, 3)

Google Sheets Index displays the data, in the cell at the intersection of row 5 and column 3, in the range A2 to D6, in the cell you type the Google Sheet Index function.

What does the INDEX function return, if you omit the row and column attributes? It returns the data in the entire range. In the example above, the function copies the data in the range
A2 to D6 to the cells, starting from the cell you typed the INDEX formula.

It is common to nest the MATCH function inside the INDEX function to extract data. What is an advantage of this approach? You do not have to hard code the row and column number. Instead, you can let the MATCH function provide the two attributes to Google Sheets Index.

The MATCH function returns the search key position, which is a number.

---------------------------
Google Sheets MATCH Tutorial

Here is the link to the step-by-step tutorial:

   • Google Sheets Match | Match Function Googl...  


Google Sheets MATCH Quiz

Here is the link to the quiz:

   • Google Sheets Quiz on MATCH function | Spr...  
-----------------------------

If you wish to extract data from a cell in a Google Spreadsheet easily, the Google Sheets INDEX is a right choice. Please take a look at this tutorial, which explains the INDEX function with an example.