Thanks to Mike Tholfsen, you can get to grips with these new Excel functions in just 5 minutes. This video is an informative and concise overview of the functions we’ve just covered. If you prefer a video tutorial, we’ve also attached our favourite guide to new Excel formulas in 2022 here: Under Product Information, note the version number under the About section.

If you want to go further, you can also watch this video tutorial on XLOOKUP by LinkedIn Learning: Using the XLOOKUP function. Open any Office application, such as Word or Excel.

This guide from ExcelKid covers 5 common problems with XLOOKUP and how to solve them: 5 Reasons why XLOOKUP is Not Working.

This helpful blog by Inferogroup covers exactly why XLOOKUP is a more efficient function than VLOOKUP: XLOOKUP – The New Improved VLOOKUP.

Interested in learning more? Check out these articles below: It’s been available in Office365 and Excel for web since 2020, but we still can’t get enough of this feature in 2022! XLOOKUP is a powerful look-up function that can go far beyond the limitations of VLOOKUP and the INDEX and MATCH functions. If you’re an Excel aficionado, you must know the XLOOKUP formula.

Latest excel version 2021