Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video, learn how one solution can take care of both #VALUE! errors and Absolute Reference errors when working with XLOOKUP formulas.
If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/functions/xlookup-errors

Related Videos:

Shortcuts for writing XLOOKUP and VLOOKUP formulas:
https://www.youtube.com/watch?v=Tb9KWQMaLtw

When to use VLOOKUP instead of XLOOKUP:
https://www.youtube.com/watch?v=CQAhPRCAjA8

XLOOKUP for Excel: Explained in 3 Minutes:
https://www.youtube.com/watch?v=txK0C6SkaMg

The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel:
https://www.youtube.com/watch?v=pURSha68Mjs

VLOOKUP Tutorial for Excel - Everything You Need To Know:
https://youtu.be/d3BYVQ6xIE4:

00:00 Introduction
00:24 XLOOKUP Formula
02:54 Insert Table

#MsExcel #ExcelCampus