To find and retrieve data from a vertical lookup table in the most efficient way, create a simple worksheet that contains related data, and organize this data in ____ to form the vertical lookup table.
A) columns
B) rows
C) either a or b
D) neither a nor b

Question

Quizplus · Accepted Answer

To create a vertical lookup table, the data needs to be organized in columns. The first column should contain the lookup values, and the columns to the right should contain the related data. This allows for easy use of the VLOOKUP function, which requires the lookup value to be in the first column.

To Find and Retrieve Data from a Vertical Lookup Table