Question

When using VLOOKUP or HLOOKUP for a "Exact Match" lookup with a range of values, which argument should you use?

A) TRUE
B) FALSE
C) 1
D) 0

Answer 1

When using VLOOKUP or HLOOKUP for an Exact Match lookup with a range of values, you should use option FALSE.

Step-by-step explanation:

When using VLOOKUP or HLOOKUP for an Exact Match lookup with a range of values, you should use option FALSE. This argument searches for an exact match and returns the corresponding value from the table. Using TRUE or any non-zero value would result in an approximate match, which may not give the desired result.

For example, if you have a table with student names and their corresponding grades, and you want to find the grade of a specific student, you would use FALSE to ensure an exact match.