Microsoft Excel’s Versatile XLOOKUP Function

Introduction

Microsoft Excel has several functions categorized as lookup functions. Many of them can be replaced by the versatile XLOOKUP function. The XLOOKUP function can replace the VLOOKUP, HLOOKUP, and INDEX + MATCH functions. However, the XLOOKUP function is only available in Excel for Microsoft 365. If you have an older Excel version, you’ll need to use one of the other…