Uploaded June 2019 | Updated November 2026, 2 days ago
Are you struggling to get Online Exchange Rates In Excel, this video will exactly show you a simple step explaining how to get currency exchange prices in Excel. All this can be done with New Built-in Feature in Microsoft 365 Excel Stocks Data Types.
00:00 Into
00:27 Using the currency Excel Converter
01:25 Convert EUR To INR
01:36 Souce of Excel Exchange Rate
02:40 Handling missing currency format in Excel
03:20 Using Excel Tables to get online exchange rates
04:50 End Screen
👍🏻 Like us on Facebook
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
🥇🥈🥉Top N Values | Easy Solution with NEW Dynamic Arrays (macOS & Windows)
youtu.be/DexVJUA-j8A
-----------------------------------------------
New Excel Data Types Stock 💹 & Geography 🗺️ (Office365)
youtu.be/NZN0wP2A770
-----------------------------------------------
🔍Simple way of using Index & Match explain in detail.
youtu.be/a8zKuoDopEI
-----------------------------------------------
📊 Averaging Top Values, LARGE, SEQUENCE | Classic & Dynamic Arrays
youtu.be/QNKdW2GDQYU
-----------------------------------------------
🤖Excel New Ai Engine | 📸Insert Data From Picture
youtu.be/Fh9-K5uNG9I
***********************************************************
#Excel #ExcelExciting #FarazShaikh #DataTypes #MicrosoftCreators #ProductivityHack #FarazExcelMaster #FarazShaikh #MadeWithCamtasia
Are you struggling to get Online Exchange Rates In Excel, this video will exactly show you a simple step explaining how to get currency exchange prices in Excel. All this can be done with New Built-in Feature in Microsoft 365 Excel Stocks Data Types.
00:00 Into
00:27 Using the currency Excel Converter
01:25 Convert EUR To INR
01:36 Souce of Excel Exchange Rate
02:40 Handling missing currency format in Excel
03:20 Using Excel Tables to get online exchange rates
04:50 End Screen
👍🏻 Like us on Facebook
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
🥇🥈🥉Top N Values | Easy Solution with NEW Dynamic Arrays (macOS & Windows)
youtu.be/DexVJUA-j8A
-----------------------------------------------
New Excel Data Types Stock 💹 & Geography 🗺️ (Office365)
youtu.be/NZN0wP2A770
-----------------------------------------------
🔍Simple way of using Index & Match explain in detail.
youtu.be/a8zKuoDopEI
-----------------------------------------------
📊 Averaging Top Values, LARGE, SEQUENCE | Classic & Dynamic Arrays
youtu.be/QNKdW2GDQYU
-----------------------------------------------
🤖Excel New Ai Engine | 📸Insert Data From Picture
youtu.be/Fh9-K5uNG9I
***********************************************************
#Excel #ExcelExciting #FarazShaikh #DataTypes #MicrosoftCreators #ProductivityHack #FarazExcelMaster #FarazShaikh #MadeWithCamtasia






![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)



