USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
|
|
=VLOOKUP(lookup ____ value, table ____ array, col ____ index ____ num, range ____ lookup)
|
|
|
=VLOOKUP(table ____ array, lookup ____ value, col ____ index ____ num, range ____ lookup)
|
|
|
=VLOOKUP(lookup ____ value, table ____ array, col ____ index ____ num, value)
|
|
|
=VLOOKUP(lookup ____ value, table ____ array, col ____ index ____ num, range ____ lookup, value)
|
Explanation:
Detailed explanation-1: -In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Detailed explanation-2: -The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number. The lookup value is the value for which you want to find matching data and must appear in the first column of the lookup table; it can be a value, a text string, or a cell reference.
Detailed explanation-3: -The VLOOKUP(value, range, result column, exact match) is correct.
There is 1 question to complete.