DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
table array
|
|
|
worksheet
|
|
|
workbook
|
|
|
list
|
Detailed explanation-1: -The syntax for VLOOKUP is =VLOOKUP (value, table array, col index, [range lookup]). In its general format, you can use it to look up on one column at a time. However, tweaking the formula allows us to use VLOOKUP to look across multiple columns.
Detailed explanation-2: -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.
Detailed explanation-3: -Column Index Number = The column number in table from which the matching value must be returned. This number should not be greater than the number of columns in the table array otherwise, it will show error #REF!. Range Lookup = This is optional value.
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.