VLOOKUP Function
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
*lookup_value:* what are you searching for? This is the lookup value. Excel will search for a match to this value in the leftmost column of your lookup table *Table_array:* Where do you want to search? This is the lookup table. If you plan to copy your VLOOKUP formula, you may want to use absolute references to "lock" the range *Col_index_num*: Which column contains the search results? This value will appear in the cell with the VLOOKUP formula. COunt over form the first colum to figure out what this number should be, starting with 1 *Range_lookup*: should the lookup value be an exact match (FALSE or 0) or is an approximate mate (TRUE or 1) okay if an exact math doesnt exist? For TRUE, sort the leftmost column in ascending order for correct results
What is the Table_array argument a. The lookup table b. Where you want to search c. Both of the above
C The table-array argument is also called the lookup table. It's where you want VLOOKUP to search
What is the col_index_num argument? a. the column number for your search result column b. the column heading for your search results column
a you count, starting at one with the leftmost column across the list or table to get the number of the column that contains the search result
The range_lookup argument is either True, or False. With False, you get with of the following? a. an approximate match b. an exact match
b
When you use VLOOKUP, you must do which of the following? a. have a list or table arranged in vertical columns b. Use a lookup_value in the leftmost column of the lookup table c. Use the column number, counting from the left, that contains the search results d. Indicate whether the range_lookup is True (approximate) or False (exact) e. All of the Above
e. All of the Above --the VLOOKUP essentials
if you range_lookup argument is True, you need to sort the leftmost column in ascending order true false
true sort the leftmost column in ascending order (or from a through z), or you may get the wrong results
The lookup_value argument (the value you are searching for) must be in the leftmost column of your list or table true false
true --excel looks for the lookup_value in the first, or leftmost column of your list or table. If the lookup_value is in some other column, VLOOKUP wont work
