Use XLOOKUP & XMATCH to Lookup last matching value in the column @ExcelExciting
Use XLOOKUP & XMATCH to Lookup last matching value in the column  @ExcelExciting
Uploaded September 2021 | Updated November 2026, 4 days ago
In this video, we will learn how to use XLOOKUP & XMATCH to get the last record or lookup the last matching value in a column. In order to achieve the last record value. XLOOKUP & XMATCH have made the construction of the formula very easy comparing with the classic way of building the formula. This solution will work with the new Excel Calculation engine & Excel Online only.

โฑ Time Stamp
00:00 Intro
00:40 Understanding Dataset
01:35 XLOOKUP last match value
03:10 XMATCH last match value
04:00 Handling Index #REF! error with XMATCH
04:35 End

--------------------------------------------------------------
๐Ÿ›’ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk

๐Ÿ“ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family ๐Ÿ‘จโ€๐Ÿ‘ฉโ€๐Ÿ‘งโ€๐Ÿ‘ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ŸŒŽ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐Ÿ‘๐Ÿป Like Facebook Page :
facebook.com/ExcelExciting

๐Ÿ‘ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
youtu.be/ROym3e-S4OQ

Lookup last matching value in the column (Excel - Mac & Windows)
youtu.be/bh9ELJflc_Y

Learn Exactly How to Get Crude Oil, Natural Gas & Other Commodities Prices in Excel
youtu.be/lLoY1mnZYEw

Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
youtu.be/iei5rMstlJ0

***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Use XLOOKUP & XMATCH to Lookup last matching value in the columnExcel Tip by the Excel Queen ๐Ÿ‘ธ๐Ÿป(Faraz Shaikh & Leila Gharani)Excel Trick# 17 - Separate First & Last Name (TEXTSPLIT) #shorts  #excel #exceltips #exceltricksPivot Tables simplicity or CUBE Functions flexibility? You decide with Bernard Obeng BoatengUnboxing Apple Macbook M1 Pro (16inch) - #Shorts 0005Discover DAX Fundamentals Through Common Mistakes with Fowmy AbdulmuttalibData Quality With Dynamic Arrays with Oz du SoleilRight way to ALWAYS download Microsoft Office Mac from Office.comExcel Trick# 35 โ€“ Remove Formulas from Filtered Data OnlySort Problem With Numbers As Text SOLVED โœ… (Excel for mac & windows)Excel Trick# 25 - Create a Dropdown List in Excel Typed List #shorts #excel #excelexcitingAdvanced Financial Analytics Dashboard in Microsoft POWER BI with Rahim Zulfiqar Ali
Faraz Shaikh |

Use XLOOKUP & XMATCH to Lookup last matching value in the column

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER