Uploaded February 2023 | Updated September 2026, 3 hours ago
Join 300,000+ professionals in our courses: xelplus.com/courses
In this video you'll learn 4 different methods to hide values in Microsoft Excel including a cool Excel trick you can use with custom number formatting in Excel.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Join 300,000+ professionals in our courses: xelplus.com/courses
In this video you'll learn 4 different methods to hide values in Microsoft Excel including a cool Excel trick you can use with custom number formatting in Excel.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π Excel RESOURCES I Recommend: xelplus.com/resources
π₯ GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
π This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel








![The Only VLOOKUP Guide Youβll Ever Need. (No More Errors)
π₯ Want results you can see? Join 500,000+ professionals upgrading their skills. Start your journey today π https://link.xelplus.com/yt-d-all-courses
Whether you are looking up data from another sheet or trying to fix a stubborn #N/A error, this ultimate guide covers everything you need to become an Excel pro. We start with the basics of Exact Match logic and move into advanced troubleshooting, including how to handle spaces with the TRIM function and how to use IFNA for clean reports.
β¬οΈ Download the free practice workbook here: https://www.xelplus.com/vlookup-function/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-vlookup&utm_content=vlookup-new#download-section
Whatβs covered in this guide:
- Exact Match vs. Approximate Match: Why skipping the last argument is the #1 VLOOKUP mistake [03:56].
- Multi-Sheet Lookups: How to pull data from different tabs without breaking your links [05:27].
- Troubleshooting #N/A Errors: Common pitfalls like the Left-Side Rule and hidden spaces [09:12].
- Range Lookups: Using VLOOKUP for grading scales and numeric ranges [07:08].
- Error Handling: Using IFNA and IFERROR to replace ugly error codes with custom text [13:35].
Youβll learn how to quickly find information from different sheets, get exact or closest matches, and troubleshoot common errors. VLOOKUP Excel saves you time and reduces mistakes by automating data searches across your spreadsheets.
00:00 Why You Need to Master VLOOKUP in 2026
00:50 How to Do a VLOOKUP Formula
01:52 Understanding Syntax: Lookup Values and Table Arrays
03:56 The #1 VLOOKUP Mistake: Exact Match (FALSE) vs. Approximate
05:27 How to Use VLOOKUP Across Different Sheets
07:08 Approximate Match Tutorial: Grading Scales and Ranges
09:12 Common Errors: Why your VLOOKUP is returning #N/A
10:05 Pro Tip: Why Sorting Matters for Approximate Match
11:35 Fix Hidden Spaces: Combining VLOOKUP with TRIM [12:01]
12:24 The Left-Side Rule: Why Column Order Matters
13:35 Clean Reports: Using IFNA and IFERROR to Hide Errors
14:31 Should You Use XLOOKUP Instead?
We start with the basics: how to do a VLOOKUP to find related information, like a customerβs profession from another dataset. Youβll learn how to set up your data range correctly and discover the importance of fixing the table array to avoid shifting ranges when copying formulas. This practical VLOOKUP example shows you the essentials of how to use VLOOKUP effectively.
We also dive into advanced VLOOKUP techniques, including how to use VLOOKUP across different sheets, how to find exact matches with the FALSE parameter, and how to handle approximate matches efficiently. Plus, we tackle common VLOOKUP errors and show you how to correct them using simple adjustments and functions like TRIM and IFNA.
By the end of this video, youll be equipped to use the VLOOKUP formula confidently. Youβll understand why itβs a go-to tool for Excel users seeking to streamline their data analysis tasks.
π¨ Subscribe to Between the Sheets newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
β‘οΈ Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π¬ LINKS to related videos:
How to Use the NEW & IMPROVED Excel XLOOKUP: https://youtu.be/4c0CLUER6nw
How to do a Left Lookup in Excel: https://youtu.be/Xz1KHEhqUCY
π Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
π Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
π₯ RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel The Only VLOOKUP Guide Youβll Ever Need. (No More Errors)](https://i.ytimg.com/vi/TDphx23AtqM/mqdefault.jpg)

