Vlookup Revision Starter

$B$15 is an Absolute Reference

• True

• False

VLOOKUP() searches in the first row of the table.

• True

• False

A named range is a relative reference

• True

• False

IS this the correct syntax for VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup])?

• True

• False

It is best to use a named range for the table reference in VLOOKUP, especially if you want to copy the formula.

• True

• False

VLOOKUP() stands for Virtual Lookup

• True

• False

The cell reference in a relative reference do not change when you drag a formula

• True

• False

HLookup is Vlooup but turned 90 degrees clockwise

• True

• False