December 3, 2020

INDEX Function in Google Sheet

The Index function is used to find the any value in the known position of a table in both excel and Google sheet.

Below is the use of index function when you only know the row number of a list.

=INDEX(table, row number)

Below is the use of Index function when you know both row and column number of a table.

=INDEX(table, row number, column number)

Note : The row number starts from the first row of the table specified in the formula. Same for column number.

Leave a Reply

Your email address will not be published. Required fields are marked *