222k views
0 votes
The VLOOKUP function "looks up" a value and evaluates (compares) it against values in a lookup_table (the "key data") in order to return a matching "answer." When constructing a table_array to be used as lookup reference table, the "key data" should be placed in the _____.

A. First column
B. Second column
C. Last column
D. Any random column

1 Answer

3 votes

Final answer:

The "key data" should be placed in the First column when constructing a table_array for the VLOOKUP function.

Step-by-step explanation:

When constructing a table_array to be used as a lookup reference table in the VLOOKUP function, the "key data" should be placed in the First column. This means that the values you want to look up and compare should be in the leftmost column of the table.

User Fatemeh Qasemkhani
by
7.8k points