DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is NOT a Vlookup argument?A. lookup ____ arrayB.lookup ____ valueC.col ____ index ____ numD.row ____ index ____ num
|
|
Only D
|
|
|
A and D
|
|
|
B and C
|
|
|
A and C
|
Explanation:
Detailed explanation-1: -The VLOOKUP function has the following syntax for its four arguments: VLOOKUP(lookup value, table array, col index num, [range lookup])
Detailed explanation-2: -VLOOKUP Cannot Look to its Left A limitation of the VLOOKUP function is that it cannot look to its left. It will look down the leftmost column of a table and return information from the right.
Detailed explanation-3: -The Col index num (Column index number) is the relative column number in the list. Nothing to do with where it is in Excel, it’s the column number in the table.
There is 1 question to complete.