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

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...

Related Videos:

Shortcuts for writing XLOOKUP and VLOOKUP formulas:
   • Writing Formulas Made Easy With Short...  

When to use VLOOKUP instead of XLOOKUP:
   • VLOOKUP vs. XLOOKUP - What's the diff...  

XLOOKUP for Excel: Explained in 3 Minutes:
   • Xlookup In Excel: Explained In 3 Minutes  

The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel:
   • New Xlookup Function: A Vlookup Compa...  

VLOOKUP Tutorial for Excel - Everything You Need To Know:
   • Excel Vlookup Tutorial - Everything Y...  :

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

#MsExcel #ExcelCampus