DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What are the advantages of the index match function compared to the Vlookup and Hlookup functions____
|
|
Can search data from any direction range
|
|
|
Can search data only from the right data range
|
|
|
Can search only data from column AZ to A
|
|
|
Can search data from line 1 to 30
|
Explanation:
Detailed explanation-1: -VLOOKUP will only work if the lookup value is in the first column. VLOOKUP cannot look to its left. However, INDEX MATCH solves this problem as it performs the lookup both horizontally and vertically. So, it doesn’t require the lookup value to be in the first column, it can be anywhere.
Detailed explanation-2: -When you’re trying to look up a value based on a single input, you may be able to use a *LOOKUP function. If you’re explicitly asked to find the location of a single input, or to look something up using two or more pieces of information, you’ll need to use the MATCH and/or INDEX functions instead.
There is 1 question to complete.