Question:

What value of range look up in VLOOKUP() and HLOOKUP() is used for returning only exact value?

Show Hint

In VLOOKUP and HLOOKUP the range lookup value FALSE returns only an exact match.
Updated On: Oct 26, 2026
  • False
  • True
  • Blank
  • Zero
Show Solution
collegedunia
Verified By Collegedunia

The Correct Option is A

Solution and Explanation

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).
Was this answer helpful?
0
0