DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MATCH
|
|
|
SEARCH
|
|
|
HLOOKUP
|
|
|
VLOOKUP
|
Detailed explanation-1: -The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Detailed explanation-2: -Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let’s say you know the part number for an auto part, but you don’t know the price.
Detailed explanation-3: -Excel LOOKUP function-vector form. In this context, a vector refers to a one-column or one-row range. Consequently, you use the vector form of LOOKUP to search one row or one column of data for a specified value, and pull a value from the same position in another row or column.
Detailed explanation-4: -What Is a LOOKUP Function? Lookup functions in Excel mean referencing a cell to match values in another row or column against the cell and thereby retrieving the corresponding results from the respective rows and columns.
Detailed explanation-5: -=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).