The equivalent VLOOKUP formula in this case would be: =VLOOKUP(F2,B2:D11,3,FALSE)Įxample 2 looks up employee information based on an employee ID number.

Note: XLOOKUP uses a lookup array and a return array, whereas VLOOKUP uses a single table array followed by a column index number. It doesn't include the match_mode argument, as XLOOKUP produces an exact match by default. It includes the lookup_value (cell F2), lookup_array (range B2:B11), and return_array (range D2:D11) arguments. If not sorted, invalid results will be returned.Įxample 1 uses XLOOKUP to look up a country name in a range, and then return its telephone country code. 2 - Perform a binary search that relies on lookup_array being sorted in descending order. If not sorted, invalid results will be returned. 1 - Perform a reverse search starting at the last item.Ģ - Perform a binary search that relies on lookup_array being sorted in ascending order. If none found, return the next larger item.Ģ - A wildcard match where *, ?, and ~ have special meaning.ġ - Perform a search starting at the first item. If none found, return the next smaller item.ġ - Exact match. If a valid match is not found, and is missing, #N/A is returned.Ġ - Exact match. Where a valid match is not found, return the text you supply. *If omitted, XLOOKUP returns blank cells it finds in lookup_array. =XLOOKUP(lookup_value, lookup_array, return_array, , , )

If no match exists, then XLOOKUP can return the closest (approximate) match.

The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds.

Microsoft word blank check template