DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
0 for approximate look value and 1 for exact look value.
|
|
|
0 for looking in Master database and 1 for looking in table array.
|
|
|
Range lookup is optional hence doesn’t matter
|
|
|
0 for exact look value and 1 for approximate look value.
|
Detailed explanation-1: -In this, you will enter whether the search value should retrieve the approximate match or an exact match. If you want an approximate match, then enter the value as 1, which represents true there. If you want an exact match, then enter the value as 0, which represents false there.
Detailed explanation-2: -=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Detailed explanation-3: -VLOOKUP function retrieves a 0 value when the value in column C is an empty cell. To convert 0 to an empty string we can use LEN and IF functions. LEN function has the result 0 for the blank cells.
Detailed explanation-4: -Searches for an approximate value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array.
Detailed explanation-5: -The most common cause of the #N/A error is with XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, or MATCH functions if a formula can’t find a referenced value. For example, your lookup value doesn’t exist in the source data. In this case there is no “Banana” listed in the lookup table, so VLOOKUP returns a #N/A error.