DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Average
|
|
|
HLOOKUP
|
|
|
Count
|
|
|
VLOOKUP
|
|
|
If
|
Detailed explanation-1: -Use the combination of INDEX and MATCH functions instead. This example shows a small list where the value we want to search on, Chicago, isn’t in the leftmost column. So, we can’t use VLOOKUP. Instead, we’ll use the MATCH function to find Chicago in the range B1:B11.
Detailed explanation-2: -Use the VLOOKUP function to look up a value in a table. For example: =VLOOKUP(A2, A10:C20, 2, TRUE)
Detailed explanation-3: -LOOKUP() The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column.
Detailed explanation-4: -VLOOKUP is one of the lookup and reference functions in Excel is used to find values in a specified range by “row”. It compares them row-wise until it finds a match. In order for VLOOKUP to work, the lookup value must be on the left-most column on the table array.