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