Excel XLOOKUP function | Exceljet With a straightforward syntax, XLOOKUP can be configured to support wildcards, regex, approximate‑match, reverse, and high‑speed binary searches Key features include: The ability to look up values in vertical or horizontal ranges Support for a default value when a lookup operation fails