The function returns a value or reference of the cell at the intersection of a particular row and column in a given range.
A) VLOOKUP(lookup_value, table_array, col_index_num)
B) INDEX(array, row_num, col_num)
C) MATCH(lookup_value, lookup_array, match_type)
D) HLOOKUP(lookup_value, table_array, row_index_num)

Question

Quizplus · Accepted Answer

The INDEX function is designed to return a value or reference of a cell at the intersection of a row and column within a given range. The row and column numbers can be specified as arguments, allowing for great flexibility in selecting specific cells within a range.

The Function Returns a Value or Reference of the Cell