The INDEX function below returns a specific value in a one-dimensional range. Type INDEX and select the area of the table then add a comma. 92 found at the intersection of row 3 and column 2 in the range E4F7.
Type the column number for Height which is 2 and close the bracket.
INDEX array row_num col_num INDEX array row_num col_num area_num array a range of cells or an array constant. Here is a simple guide to help you write the formula until youve practiced enough to memorize it. Use INDEX and MATCH in Excel and impress your boss. Despite this popularity INDEX MATCH is by no means perfect and is still prone to errors.