Using the VLOOKUP function,an approximate match lookup occurs when the value entered falls within a range of values in ____ of the lookup table.
A) the first column
B) any column
C) the first row
D) any row

Question

Quizplus · Accepted Answer

An approximate match lookup in VLOOKUP occurs in the first column of the lookup table, where the value entered falls within a range of values. This column should be sorted in ascending order for accurate results.

Using the VLOOKUP Function,an Approximate Match Lookup Occurs When the Value