The Function Returns a Value or Reference of the Cell

Multiple Choice

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)