Index Match Excel. Combining index and match by combining the index and match functions we have a comparable replacement for vlookup. Index is configured with an array that includes all the data in the table and the column number is hard coded as 2.
Find the position of an item in a range. Once match returns 4 we have. Index then retrieves the value at the intersection of the 4th row and 2nd column in the array which is 1995.
But when you combine the two functions they create an extremely powerful tool to search arrays of data and return their desired results.
The index and match combination is essentially a more powerful and flexible version of the vlookup function which itself is a. Index data array match vlookup value lookup column range 0 match hlookup value lookup row range 0. Index is configured with an array that includes all the data in the table and the column number is hard coded as 2. Match finds the position by using a lookup value.
