The INDEX and MATCH | syntax and use
The INDEX and MATCH syntax and use.
The MATCH returns the position of the value (in which row or column).
We need to provide the search key.
The range where we find the search key.
The range should be a single row or a single column.
And the search type (zero for exact match).
The INDEX function returns a value from a range if we provide its row and column number.
We use the match function to provide the row and column numbers.
=INDEX(A2:B14,MATCH(G1,A2:A14,0),MATCH(B2,A2:B2,0))
