Type INDEX and select the area of the table then add a comma Type the row number for Kevin which is 4 and add a comma Type the column number for Height which is 2 and close the bracket The result is 58. Normally an INDEX MATCH formula is configured with MATCH set to look through a one-column range and provide a match based on given criteria. 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.
INDEX MATCH is not a function in Excel but a combination of two formulas INDEX and MATCH INDEX MATCH can be used as an alternative to old school VLOOKUP.
The result is 395 the price of the Caffe Mocha size Grande. How to use INDEX and MATCH The INDEX Function. Excel must first calculate the result of the two MATCH formulas embedded within the INDEX formula. Check the Excel Essentials Course.