Extract value where the row, column intersects (INDEX, MATCH function) As data in Excel can be large, it is difficult and time consuming for us to find the cell or value wanted. There are 2 functions that help us extract the information we need using the row, column, or heading of the table as reference. =INDEX(array, row_num, [column_num]) [array]・・・