DATABASE FUNDAMENTALS
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: -Approximate match-1/TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don’t specify one. For example, =VLOOKUP(90, A1:B100, 2, TRUE).
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: -VLOOKUP Formula Lookup value (required argument) – Lookup value specifies the value that we want to look up in the first column of a table. Table array (required argument) – The table array is the data array that is to be searched. The VLOOKUP function searches in the left-most column of this array.