Presuming you are using the below Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value can be a value or a reference. If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.
Presuming you are using the below Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value can be a value or a reference. If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.
Good luck