If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the ____ error value.
A) #N/A
B) ##
C) #ERROR#
D) @#@#

Question

Quizplus · Accepted Answer

When the lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP function returns the #N/A error value. This is because the lookup value cannot be found in the table and therefore, there is no matching value to return.

If a Lookup_value Is Smaller Than the Smallest Value in the First