A setting in lookup functions that determines whether to search for an identical value or the nearest value in a sorted list.
Thử với AIExact match requires the lookup value to be identical to the target, returning an error if not found. Approximate match searches for the largest value less than or equal to the lookup value, requiring the source data to be sorted in ascending order.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Use exact match to find a specific employee ID, but use approximate match to determine a tax bracket based on a salary range.
The function will return incorrect or unpredictable results because it stops searching as soon as it encounters a value larger than the lookup value.