In the function =VLOOKUP(C1,A1: B9,2,False),the A1: B9 assignment indicates the ____.
A) Lookup_Value
B) Table_Array
C) Col_Index_num
D) Range_lookup

Question

Quizplus · Accepted Answer

The A1:B9 assignment in the VLOOKUP function indicates the table array. The table array is the range of cells that contains the data to be searched, and it includes both the lookup value column and the result column.

In the Function =VLOOKUP(C1,A1: B9,2,False),the A1: B9 Assignment Indicates the ____