INDEX C6G10. If you try to enter the brackets yourself Excel will display the formula as text. Once MATCH runs the formula simplifies to.
The MATCH function returns a 4 to the row_num argument in INDEX.
When you use an array in INDEX MATCH or a combination of those two functions it is necessary to press CtrlShiftEnter on the keyboard. Formulas are the key to getting things done in Excel. In the example above I used a 4 for the row_num argument for INDEX. The INDEX function returns the 5th value second argument in the range E3E9 first argument.