INDEX array row_num col_num INDEX array row_num col_num area_num array a range of cells or an array constant. Excel will automatically enclose the formula within curly braces. The INDEX function returns the 5th value second argument in the range E3E9 first argument.
VLOOKUP and INDEX-MATCH formulas are among the most powerful functions in Excel.
MATCH Formula in Excel The MATCH Function checks for a particular value in a range of cells and returns the respect location of that value. Here is one example to IF INDEX and MATCH combination in Excel. Formulas are the key to getting things done in Excel. INDEX array row_num col_num INDEX array row_num col_num area_num array a range of cells or an array constant.