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))
Watch video The INDEX and MATCH | syntax and use online without registration, duration hours minute second in high quality. This video was added by user Google Workspace Tutorial 17 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 49 once and liked it 1 people.