## Basic INDEX MATCH exact in Excel

This tutorial shows how to calculate Basic INDEX MATCH exact in Excel using the example below; Formula =INDEX(data,MATCH(value,lookup_column,FALSE),column) Explanation This example shows how to use INDEX and MATCH to get information from a table based on an exact match. In the example shown, the formula in cell H6 is: =INDEX(B5:E9,MATCH(H4,B5:B9,FALSE),2) which returns 1995, the year …