USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
It is an easy and fast way to look for a data.
|
|
VLOOKUP
|
|
|
PROPER
|
|
|
SUM
|
|
|
AVERAGE
|
Explanation:
Detailed explanation-1: -But if we move the lookup table to another worksheet, the formula starts working much faster ( 5 seconds), which is better than VLOOKUP.
Detailed explanation-2: -Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
Detailed explanation-3: -VLOOKUP looks from left to right! VLOOKUP looks for the lookup value in the leftmost column of the table array. That means whatever you want to return must be located somewhere to the right of the column you’re searching in.
There is 1 question to complete.