USING MICROSOFT EXCEL
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: -=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-2: -Exact match in Vlookup In the exact match, the lookup value we have entered is being searched in the table and it returns the value only when there is an exact match. Let’s look at a sample: In the above sample, we have entered the range lookup value as 0 which represents to lookup for the exact value match.
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.