INDEXB2F5 MATCHA8A2A5 0 MATCHB8 B1F1 0 Instead of the cell reference C8 in the INDEX formula we now have the MATCH formula we entered in to cell C8 previously. How to Use the INDEX MATCH Function in Excel. The MATCH function searches for a specified item in a range of cells and then returns the relative position of that item in the range.
This is a variation of the classic INDEX MATCH formula to which you add one more MATCH function in order to get both the row and column numbers.
The INDEX function returns the 5th value second argument in the range E3E9 first argument. The INDEX function returns the 5th value second argument in the range E3E9 first argument. Replace the value 5 in the INDEX function see previous example with the MATCH function see first example to lookup the salary of ID 53. For example if the range A1A3 contains the values 5 25 and 38 then the formula MATCH25A1A30 returns the number 2 because 25 is the second item in the range.