Page 8 of 9PREVNEXT

VLOOKUP: What it is, and when to use it

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


The lookup_value argument (the value you are searching for) must be in the leftmost column of your list or table.

True.

False

What is the table_array argument?

The lookup table.

Where you want to search.

Both of the above.

What is the col_index_num argument?

The column number for your search result column.

The column heading for your search result column.

The range_lookup argument is either True, or False. With False, you get:

An approximate match.

An exact match.

If your range_lookup argument is True, you need to sort the leftmost column in ascending order.

True.

False.

When you use VLOOKUP, you must

Have a list or table arranged in vertical columns.

Use a lookup_value in the leftmost column of the lookup table.

Use the column number, counting from the left, that contains the search result.

Indicate whether the range_lookup is True (approximate) or False (exact).

All of the above.

Page 8 of 9PREVNEXT