Cut the MATCH formula for Kevin and replace the “4” with it.Now we can take the two MATCH formulas and use them to replace the “4” and the “2” in the original INDEX formula. The result is that Height is in column “2.”.Select all the cells across the top row of the table.Type “=MATCH(” and link to the cell containing “Height”… the criteria we want to look up.Use MATCH again to figure out what column Height is in. The result is that Kevin is in row “4.”.Select all the cells in the Name column (including the “Name” header).Type “=MATCH(” and link to the cell containing “Kevin”… the name we want to look up.Sticking with the same example as above, let’s use MATCH to figure out what row Kevin is in. Type the column number for Height, which is “2,” and close the bracket.Type the row number for Kevin, which is “4,” and add a comma.Type “=INDEX(” and select the area of the table, then add a comma.We want to use the INDEX formula to look up Kevin’s height… here is an example of how to do it. #1 How to Use the INDEX Formulaīelow is a table showing people’s names, height, and weight. To see a video tutorial, check out our free Excel Crash Course. For short, this is referred to as just the Index Match function. =MATCH() returns the position of a cell in a row or column.Ĭombined, the two formulas can look up and return the value of a cell in a table based on vertical and horizontal criteria. =INDEX() returns the value of a cell in a table based on the column and row number.
The INDEX MATCH Formula is the combination of two functions in Excel: INDEX and MATCH.
0 kommentar(er)
