Tag: XLOOKUP
VLOOKUP vs XLOOKUP, What’s the Difference and When to Use Them
The “new” XLOOKUP function was introduced in Excel 2021 and Office 365, and improves upon the heavily used VLOOKUP function in several ways. Let’s start by reviewing the syntax and an example of each function to understand the differences, starting with VLOOKUP.