The Excel INDEX function returns the value at a given position in a range or array. You can use index to retrieve individual values or entire rows and columns. INDEX is often used with the MATCH function, where MATCH locates and feeds a position to INDEX.
=INDEX(A1:B5,2,2) // returns value in B2 =INDEX(A1:B5,3,1) // returns value in A3
References
https://exceljet.net/excel-functions/excel-index-function