Uploaded August 2019 | Updated November 2026, 2 days ago
In this video we will learn how to use the VLOOKUP Function & also see how to handle the #NA error while construction the formula along with the best practices.
-----------------------------------------------------------------
👍🏻 Like us on Facebook
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Make VLOOKUP Column Index Dynamic (Mac & Windows)
youtu.be/W8g5jhYV-8M
------------------------------
Relative, Absolute Cell References & Mixed Reference
youtu.be/oOv80irh4HY
------------------------------
⏱Extract File Name, Path, Size,Without Macro in 10 seconds
youtu.be/kHylnj7sh-c
------------------------------
📒📚 Combine Multiple Excel Worksheets Into One Worksheet | Power Query
youtu.be/F5fjv6nXvZo
------------------------------
💱🌐Get Online Exchange Rates In Excel With New Built-in Feature Office365 (macOS & Windows)
youtu.be/3e0G0IISEpI
------------------------------------------------------
#FarazExcelMaster #ExcelTrick #ExcelTips #ProductivityHack #Camtasia #FarazShaikh #MicrosoftCreators #VLOOKUP
In this video we will learn how to use the VLOOKUP Function & also see how to handle the #NA error while construction the formula along with the best practices.
-----------------------------------------------------------------
👍🏻 Like us on Facebook
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Make VLOOKUP Column Index Dynamic (Mac & Windows)
youtu.be/W8g5jhYV-8M
------------------------------
Relative, Absolute Cell References & Mixed Reference
youtu.be/oOv80irh4HY
------------------------------
⏱Extract File Name, Path, Size,Without Macro in 10 seconds
youtu.be/kHylnj7sh-c
------------------------------
📒📚 Combine Multiple Excel Worksheets Into One Worksheet | Power Query
youtu.be/F5fjv6nXvZo
------------------------------
💱🌐Get Online Exchange Rates In Excel With New Built-in Feature Office365 (macOS & Windows)
youtu.be/3e0G0IISEpI
------------------------------------------------------
#FarazExcelMaster #ExcelTrick #ExcelTips #ProductivityHack #Camtasia #FarazShaikh #MicrosoftCreators #VLOOKUP


![How to share your videos privately on Youtube
In this video, we see how to share your YouTube videos privately and share with others
🛒 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/
👍🏻Faraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
***********************************************************
#FarazShaikh #ExcelExciting #ProductivityHack #MadeWithCamtasia #YouTube How to share your videos privately on Youtube](https://i.ytimg.com/vi/x42RE3EgmTo/mqdefault.jpg)

![Excel Hash 2021 Challenge - Secret Formula for Sales Commission
In this Excel Hash Challenge 2021, we have some great ingredients to mashup and provide solutions. This is the third edition of Excel Hash Challenge and there are some great participants around the globe. Please feel to check other participants videos & dont forget to give a vote, like & subscribe.
Vote here:
http://bit.ly/ExcelVotingTool
00:00 Intro
00:39 ExcelHash 2021 Ingredients
01:12 Understanding the dataset
01:54 Power Query Custom Data Type
05:54 Cutout Person
06:50 Dynamic Arrays (Unique Function)
08:36 Even Function
10:00 Building Solution as Dashboard
14:24 End Screen
Check out other entries:
https://www.youtube.com/playlist?list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_
ExcelHash 2021 Ingredients
- A Cutout Person
- EVEN function
At least 2 from the following:
- LET function
- Dynamic Arrays
- Custom Data Type
- LAMBDA function
🛒 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 & Power Platform 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/
***********************************************************
DISCLAIMER: If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Custom functions in Power Query (and more) with Gašper Kamenšek
https://youtu.be/Qf_i45WinRo
How to Leave or Exit an Organization in Microsoft Teams
https://youtu.be/LNJb9Jj_PYI
Insert Data from Picture In Excel for Mac
https://www.youtube.com/watch?v=3-HgzQl7Khw
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://www.youtube.com/watch?v=c8d3xx8KVl8
***********************************************************
#Excel #ExcelHash #Excel2021 #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Excel Hash 2021 Challenge - Secret Formula for Sales Commission](https://i.ytimg.com/vi/xAlUPWRnfiQ/mqdefault.jpg)

![Create Dynamic Flowcharts by connecting EXCEL to VISIO
In this video, we will learn how to create dynamic flowcharts using Microsoft Excel connecting it to Microsoft Visio
VISIO Price Plan (Affiliate Link): https://microsoft.msafflnk.net/xWP31
🛒 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/
👍🏻Faraz Shaikh - Excel Master
https://www.facebook.com/ExcelExciting/
👥Join The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
Create Organizational & Business Flowcharts Linked to Excel
https://youtu.be/Cor1mixgotY
ON-VBA Solution Convert Number to Words In Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Trick to Create A Data Entry Table In Power Query for Excel
https://youtu.be/bHPrRbcw6f0
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
***********************************************************
#VISIO #EXCEL #ExcelExciting #ProductivityHack #FarazShaikh #MicrosoftCreators #ExcelTips #MadeWithCamtasia #Excel4Windows #ExcelTricks Create Dynamic Flowcharts by connecting EXCEL to VISIO](https://i.ytimg.com/vi/xfIPFiAxQcQ/mqdefault.jpg)



