How to use VLOOKUP for fuzzy lookups in Excel

Iamlaosong

The syntax rules for this function are as follows:

VLOOKUP (Lookup_value,table_array,col_index_num,range_lookup)

Parameter simple description input data type

Lookup_value value, reference, or text string to find

Table_array the Region data table area to find

Col_index_num returns the number of columns in the range of the data in positive integers

Range_lookup Match mode TRUE (or not), FALSE

With this function, the last parameter is generally filled with 0 (FALSE), which indicates an exact match, and if not found, returns the error value #N/A. if 1 is filled, it indicates a fuzzy match, that is, if the exact match value is not found, the maximum value less than lookup_value is returned.

There is a premise, however, that the lookup column must be sorted and must be ascending, otherwise the result is unpredictable.

In addition, the search is from the first character to compare, there is no wildcard, so similar to "Anhui Postal Courier logistics Company" through the "postal courier" There is no way to match, but "Anhui post" is possible.

A function similar to this function is match, the difference is that the former returns the value of the cell, which returns the position of the cell.

This fuzzy query with trouble, the return value is not very reliable, so I think, this fuzzy query function is basically useless.

How to use VLOOKUP for fuzzy lookups in Excel