The INDEX MATCH MATCH formula finds a specific value within a two dimensional array of data, based on lookup values for the row and column. The formula combines two Excel functions, INDEX and MATCH.
The Excel MATCH function returns the relative position of an item that matches a lookup value in an array of data
The INDEX function returns a specific value across a given row and column of data.
The INDEX MATCH formula finds a specific value within an array of data, based on a lookup value. The formula combines two Excel functions, INDEX and MATCH.
The HLOOKUP function finds a specific value in a horizontal array of data, based on a provided lookup value.
The VLOOKUP function finds a specific value in a vertical array of data, based on a provided lookup value.