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.