Excel INDEX and MATCH Functions
Excel’s INDEX and MATCH functions have many uses, we’ll look at each function in isolation to understand how they work, and then we’ll use them together as an alternative to the VLOOKUP formula. How the INDEX function works: The INDEX function returns the value at the intersection of a column and a row. The syntax for the INDEX function is: =INDEX(array, row_num,[column_num]) In English: =INDEX( the range of your table , the row number of the table that your data is in , the column number of the table that your data is in ) INDEX will return the value that it is in the cell at the intersection of the row and column you specify. For example, looking at the table below in the range B17:F24 we can use INDEX to return the number of program views for Bat Man in the North region with a formula as follows: =INDEX( B17:F24 , 2 , 3 ) The result returned is 91. On its own the INDEX function is pretty inflexible because you have to hard key the row a...