Uploaded December 2021 | Updated November 2026, 3 days ago
Join us at this Excel Meetup to hear from Brandon Patterson from USA ๐บ๐ธ about "Custom Data - What Is Next?".
In this presentation, we will discuss the various options you have for database customization are wild and varied. Join us for a look at what is being offered in future data model customizations.
---------------------------
About the Speaker
---------------------------
A frequent hiker/gamer/jack of all trades. I like nothing more then to learn and utilize all things Excel and share what I learn with others.
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
Join us at this Excel Meetup to hear from Brandon Patterson from USA ๐บ๐ธ about "Custom Data - What Is Next?".
In this presentation, we will discuss the various options you have for database customization are wild and varied. Join us for a look at what is being offered in future data model customizations.
---------------------------
About the Speaker
---------------------------
A frequent hiker/gamer/jack of all trades. I like nothing more then to learn and utilize all things Excel and share what I learn with others.
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).









![Use XLOOKUP & XMATCH to Lookup last matching value in the column
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: https://amzn.to/3tR4AUN
- Buy Office365: https://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 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
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
https://youtu.be/ROym3e-S4OQ
Lookup last matching value in the column (Excel - Mac & Windows)
https://youtu.be/bh9ELJflc_Y
Learn Exactly How to Get Crude Oil, Natural Gas & Other Commodities Prices in Excel
https://youtu.be/lLoY1mnZYEw
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
https://youtu.be/iei5rMstlJ0
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Use XLOOKUP & XMATCH to Lookup last matching value in the column](https://i.ytimg.com/vi/5mxkYqXEnqA/mqdefault.jpg)
