Step 1: Understanding the Concept:
VLOOKUP and HLOOKUP look for a value in a table. The last argument is range_lookup.
It tells Excel whether to find an exact match or the nearest match.
Step 2: Working Out the Answer:
When range_lookup is FALSE, Excel returns only an exact match. If none exists, it shows #N/A.
When range_lookup is TRUE, Excel returns the nearest match (the next smaller value). The table must be sorted.
So for exact values the answer is FALSE, option (A).
Step 3: Why the Other Options Are Wrong:
Option (B): TRUE gives the approximate (nearest) match, not only the exact one.
Option (C): Blank (leaving the argument out) makes Excel assume TRUE, so it gives an approximate match.
Option (D): Zero is not the value named for this argument in the syllabus. The answer is given as FALSE.
Final Answer:
FALSE is the range lookup value used for an exact match. This is option (A).