Term
| You use VLOOKUP when the ____ of the lookup table contains the data you are looking up. |
|
Definition
|
|
Term
| When you write a VLOOKUP formula, you indicate the value you want to look up in a table |
|
Definition
|
|
Term
| In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value. |
|
Definition
|
|
Term
| In a VLOOKUP function, the argument ____ refers to the number of the column containing the data you want to retrieve. |
|
Definition
|
|
Term
| The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____). |
|
Definition
|
|
Term
| The syntax of the HLOOKUP function is as follows: HLOOKUP(lookup_value,table_array,row_index_num,range_lookup) |
|
Definition
|
|
Term
| You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type. |
|
Definition
|
|
Term
| In a FALSE VLOOKUP, if an exact match is not found, ____ is returned. |
|
Definition
|
|
Term
| A data list that categorizes values you want to retrieve is called a ____ |
|
Definition
|
|
