the Range Lookup parameter has different options. If you are not using
numeric values then use Exact Lookup and if you don't have an exact match you
will get an Error.

" wrote:

Hi all,

VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

going over some VLOOK UP basics, my question is what does it mean that
If lookup_value is smaller than the smallest value in the first column
of table_array, VLOOKUP returns the #N/A error value? how does it
determine the smallest value? also, what if the value is not
numerical?

thanks for clarifying it for me!