Google Sheets Function: INDEX

The INDEX function returns a value contained in a range based on a column and row number.


=INDEX(reference, row, column)

Example of use

The objective here is to display a value from the range A2 to C11 based on the row and column numbers entered in cells E2 and F2:

google sheets index function

Enter into the INDEX function:

The formula here is:

google sheets index function points

By combining this function with the MATCH function, it will then be possible to display the desired result based on a value in the table: INDEX + MATCH