This new lookup function is only available with Microsoft 365 (Previously known as Office 365). So if you use one of the non-subscription versions of Microsoft Office or Excel, such as Excel 2019, you’re out of luck. XLOOKUP should show under the Lookup & Reference category between VLOOKUP and another new function called VMATCH.