DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
You can lookup values located in a different worksheet.
|
|
|
You can lookup values located in a column to the right of the column that contains the lookup value.
|
|
|
You can lookup values located in a column to the left of the column that contains the lookup value.
|
|
|
You can lookup values such as text, numbers or characters.
|
Detailed explanation-1: -Now, looking at the options and comparing with our definition of a the VLOOKUP function tool, it is clear that option C is the one that is not possible with VLOOKUP.
Detailed explanation-2: -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: -Expert Answer Option c = you can lookup values located in a coloumn to the left of the colou… Transcribed image text: Question 9 Which of the following is NOT possible with VLOOKUP? You can lookup values located in a different worksheet.
Detailed explanation-4: -There are certain limitations with using VLOOKUP-the VLOOKUP function can only look up a value from left to right. This means that the column containing the value you look up should always be located to the left of the column containing the return value.
Detailed explanation-5: -One constraint of VLOOKUP is that it can only look for values on the left-most column in the table array. If your lookup value is not in the first column of the array, you will see the #N/A error.