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






![Right way to ALWAYS download Microsoft Office Mac from Office.com
In this video, we will see which is right place to download Microsoft Office apps for mac. Why there are two difference places to download Microsoft Office for Mac. We will also see how to register for Office Insider Program.
โฑ Time Stamp
00:00 Intro
00:22 Compare & how to download
02:00 Install Microsoft Office from Office.com
02:47 What is Microsoft Autoupdate
03:10 Enroll for Office Insider Program
03:30 Type of Office Insider Programs
04:30 End
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
- Resources: https://excelexciting.com/resources/
๐ฃ 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 youre helping me keep my blog up and running and youre 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.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Learn how to use Microsoft Flow/Power Automate
https://youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
https://youtu.be/xfIPFiAxQcQ
Hindi-Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/mWmgbU97ZUs
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Right way to ALWAYS download Microsoft Office Mac from Office.com](https://i.ytimg.com/vi/7UlmxqG66_E/mqdefault.jpg)

![Sort Problem With Numbers As Text SOLVED โ
(Excel for mac & windows)
In this video, we will learn how to deal with sort problems when numbers are stored as a text value in excel. We will use some simple formulas and the solution will work like magic in Excel or Google Sheets
โฑ Time Stamp
00:00 Intro
00:13 Why Numbers not sorted correctly
01:00 Building the solution
02:35 End
๐ Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
- www.ExcelExciting.com/resources
๐ฃ 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 youre helping me keep my blog up and running and youre 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.
๐ https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Excel Tip by the Excel Queen ๐ธ๐ป(Faraz & Leila)
https://youtu.be/6CEYKRIlppE
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
The easiest way to Unhide All Sheets with one line code [VBA MACRO]
https://youtu.be/cs8T8gYltvI
Double FILTER Criteria Top N Values of 2nd filtered Criteria Excel New Dynamic Arrays
https://youtu.be/hn2qSx1nivo
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Sort Problem With Numbers As Text SOLVED โ
(Excel for mac & windows)](https://i.ytimg.com/vi/7phGPaZ89DQ/mqdefault.jpg)

