Lesson#41: Combination of INDEX and MATCH function is better than any other lookup function
The INDEX function returns a value or reference of the cell at the intersection of a particular row and column, in a given range. Syntax of this function is INDEX(array, row_num, [column_num]) The array is required, If the array contains only one …
0 Comments