USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
range containing data, look for approximate match, column index number
|
|
|
range containing data, column index number, look for approximate match
|
|
|
range containing data, look for approximate match, price of the item being looked for
|
|
|
. range containing data, Price of the item being looked for, look for approximate match
|
Detailed explanation-1: -The function accepts four arguments: lookup value, table array, col index num, and range lookup. The first three are mandatory arguments, while the last one is optional.
Detailed explanation-2: -The VLOOKUP function has the following syntax for its four arguments: VLOOKUP(lookup value, table array, col index num, [range lookup])
Detailed explanation-3: -There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also called the lookup value. The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly.
Detailed explanation-4: -The approximate match and the exact match in VLOOKUP are input options in its range lookup argument. In other words, the input to this argument must only be either of the two logical inputs: 1/TRUE for approximate match and 0/FALSE for exact match.
Detailed explanation-5: -2. The approximate match returns the next largest value that is less than your specific lookup value. 3. To use the vlookup function to get an approximate match value, your first column in the table must be sorted in ascending order, otherwise it will return a wrong result.