The function returns a value or reference of the cell at the intersection of a particular row and column in a given range.
A) VLOOKUPlookup_value, table_array, col_index_num)
B) INDEXarray, row_num, col_num)
C) MATCHlookup_value, lookup_array, match_type)
D) HLOOKUPlookup_value, table_array, row_index_num)

Question

Quizplus · Accepted Answer

INDEX function returns the value or the reference to a value from within a table or range.

The Function Returns a Value or Reference of the Cell