Whereas INDEX MATCH can lookup values based on rows columns as well as a combination of both see example 3 for reference. If row_num and column_num dont point to a cell within the array. INDEX array row_num column_num.
The result is 58.
Whereas INDEX MATCH can lookup values based on rows columns as well as a combination of both see example 3 for reference. Col_num the column number from which the value is to be fetched. Download Practice File here. 92 found at the intersection of row 3 and column 2 in the range E4F7.