XLOOKUP fixes key shortcomings of VLOOKUP: it searches in any direction, has built-in error handling, and works with dynamic arrays.

VLOOKUP still works, but for new projects in modern versions of Excel (2019, 2021, 365), it's better to use XLOOKUP right away.

When working with XLOOKUP, it's important to configure the arguments correctly. We covered the details of checking three key XLOOKUP settings in a separate article on XLOOKUP errors.

🔗 Source: excel.rf