Ch. 5: VLOOKUP, HLOOKUP, rules for creating VLOOKUP & HLOOKUP tables

VLOOKUP can only retrieve data from

the right of the first column

A data list that categorizes values for retrieval is a(n) _____ table.

lookup

For the VLOOKUP function, the _____ is the data to be looked up.

lookup_value

In LOOKUP functions, use absolute refrences for the

lookup_value and table_array

The _____ argument of the VLOOKUP function is the type of lookup...the value should be either TRUE or FALSE.

range_lookup

The function =HLOOKUP(F16,Discounts,2,TRUE) retrieves the value in _____.

row 2 of the table_array

The default range_lookup is

TRUE

range_lookup can either be

TRUE or FALSE

VLOOKUP requires that the table be structured so that lookup values appear

in the left-most column

The range_lookup argument of the VLOOKUP and HLOOKUP functions is the range of values to be looked up in order to determine the function's result.

False

Values in a "closest match" vlookup table must be sorted in descending order so that the VLOOKUP function can make accurate comparisons.

False

When using VLOOKUP or HLOOKUP to look up a number that can fall within a range of values, you should be using an "Exact Match" lookup.

False

You can only use the VLOOKUP and the HLOOKUP formulas to retrieve data stored in lookup tables on the same worksheet.

False

In order to correctly use an "exact match" VLOOKUP function, the values in the first column of the lookup table must be sorted in ascending order.

False

The function =HLOOKUP(F12,$A$3:$D$10,3,TRUE) retrieves the value from the third column of the lookup table.

False

Use the _____ function to retrieve a value from a table based on the row and column numbers specified.

INDEX

When using a VLOOKUP function, the first column of the lookup table that contains the data you are comparing to your "lookup_value" is/are called the _____.

Key Data

The lookup_value argument in a VLOOKUP or HLOOKUP function is often a number, text, a logical value, or a cell reference...but the lookup_value argument can also be a formula.

True

To specify an "Exact Match" vlookup, enter the word False into the range_lookup argument of the vlookup function.

True

A LOOKUP function is used to retrieve a value from _____.

a column or row

In situations where you plan to retrieve information from more than one column in a table, or if you need to copy and paste VLOOKUP, use

absolute references

TRUE means

approx. match

The number of the column containing the data you want to retrieve for the VLOOKUP function is the _____.

col_index_num

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 _____.

column specified by the col_index_num

FALSE means

exact match

VLOOKUP always finds the

first match

In VLOOKUP, the data you want to retrieve (result values) can appear

in any column to the right