Uploaded October 2021 | Updated November 2026, 2 days ago
Join us at this Excel Meetup to hear from Bob Umlas from the USA bout the "Excel tips and tricks".
Tips and tricks for Excel, many unknown even to the experienced user
Register for the meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
Download Exercise File : https://1drv.ms/f/s!AhCxCSOesgK6hnZ5EFNoFAm3groO
---------------------------
About the Speaker
---------------------------
"Bob has been using Excel since version 0.99 (on the Macintosh)! I was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1993-2018. I’m the author of “This isn’t Excel, it’s Magic!” which is available from Amazon.com. Other books, “Excel Outside the Box” and “More Excel Outside the Box” are available from mrexcel.com and are for the very advanced Excel user. Also, there’s a kindle book, “Excel Preschool: Finally Understanding what Excel is all About” – a book for the very beginner!
I lead the New York PC User's group on Excel monthly."
--------------------------------
Connect with Speaker
--------------------------------
Email: bobumlas@hotmail.com
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55pm ZOOM Meeting opens to attendees to begin joining
- 08:00pm - 08:10pm Welcome and meeting overview
- 08:10pm - 09:30pm Feature Presentation by Speaker
- 09:30pm - 10:00pm Meeting Wrap-up
------------------
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 Bob Umlas from the USA bout the "Excel tips and tricks".
Tips and tricks for Excel, many unknown even to the experienced user
Register for the meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
Download Exercise File : https://1drv.ms/f/s!AhCxCSOesgK6hnZ5EFNoFAm3groO
---------------------------
About the Speaker
---------------------------
"Bob has been using Excel since version 0.99 (on the Macintosh)! I was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1993-2018. I’m the author of “This isn’t Excel, it’s Magic!” which is available from Amazon.com. Other books, “Excel Outside the Box” and “More Excel Outside the Box” are available from mrexcel.com and are for the very advanced Excel user. Also, there’s a kindle book, “Excel Preschool: Finally Understanding what Excel is all About” – a book for the very beginner!
I lead the New York PC User's group on Excel monthly."
--------------------------------
Connect with Speaker
--------------------------------
Email: bobumlas@hotmail.com
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55pm ZOOM Meeting opens to attendees to begin joining
- 08:00pm - 08:10pm Welcome and meeting overview
- 08:10pm - 09:30pm Feature Presentation by Speaker
- 09:30pm - 10:00pm Meeting Wrap-up
------------------
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)





