Question

The __________ news to be put at the end of the look up formulas to ensure it returns the exact match in a vlookup or hlookup formulas.

A) Good
B) Wildcard
C) False
D) Exact

Answer 1

The correct answer is D) Exact. In a VLOOKUP or HLOOKUP formula, the EXACT keyword is used to ensure an exact match.

Step-by-step explanation:

The correct answer is D) Exact.

1. In a VLOOKUP or HLOOKUP formula, the EXACT keyword is used to ensure that the formula returns an exact match.
2. When the EXACT keyword is used, the lookup value must match the search value exactly, including uppercase and lowercase letters.
3. Without the EXACT keyword, the formula might return a partial or approximate match.