XLOOKUP & XMATCH New Excel Function Explained In Detail

It is such a pleasure to make my 100th Video, you support & Love have helped me to achieve it.. Thank you. In this video we will see how to use the new XLOOKUP & XMATCH Function in Microsoft Excel, Also we will what are potential reason of error which break the formula and how to resolve the issue.

00:00 Introduction
00:39 What is new in XLOOKUP & XMATCH
02:00 Understanding XLOOKUP Syntax
03:05 VLOOKUP vs XLOOKUP
03:19 XLOOKUP Example 01 (Lookup Value from range)
03:58 XLOOKUP Example 02 (0 Extract Range Values)
05:56 XLOOKUP Example 03 (-1 Next Smaller Item or Exact Match)
07:18 XLOOKUP Example 04 (1 Next Larger Item or Exact Match)
08:25 XLOOKUP Example 05 (XLOOKUP Inside XLOOKUP Approximate match with Text)
11:30 XLOOKUP Example 06 (XLOOUP as HLOOKUP)
13:12 XLOOKUP Example 07 (Converting Range Into a reference)
18:25 XMATCH Example
18:50 End Screen

👍🏻 Like us on Facebook
  / excelexciting  

👥Join The Facebook Group -
  / excelexciting  
***********************************************************
You can check the following videos as well
Learn In 3 Minutes⏰ How To View Two Sheets Side By Side In Excel
   • Learn In 3 Minutes⏰ How To View Two S...  
------------------------------------------------
How To VLOOKUP & Handle VLOOKUP Error NA In Excel
   • How To VLOOKUP & Handle VLOOKUP Error...  
------------------------------------------------
🔮Excel Trick : How to Sum the Number With Spaces Or Special Characters
   • 🔮Excel Trick : How to Sum the Number ...  
------------------------------------------------
📒📚 Combine Multiple Excel Worksheets Into One Worksheet | Power Query
   • 📒📚Combine Multiple Excel Worksheets I...  
------------------------------------------------
💱🌐Get Online Exchange Rates In Excel With New Built-in Feature Office365 (macOS & Windows)
   • Extract Real Time Currency Exchange P...  
***********************************************************
#XLOOKUP #XMATCH #FarazExcelMaster #ExcelTrick #ExcelTips #ProductivityHack #MadeWithCamtasia #FarazShaikh #MicrosoftCreators #VLOOKUP