5 Bite-Size Vlookup Tricks for Excel
5 tricks for using Vlookup on data that might not always be 'friendly.'
This includes:
- Removing extra spaces.
- Working with multi-part lookup values.
- Dealing with Vlookup errors.
- Removing extra characters.
- Fixing Text/Number value issues.
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to use the SWITCH() function for Excel. SWITCH() allows you to match a series of valu...
Tutorial: This is a practical guide to using Variables in Macros and VBA for Excel. I will tell you ...
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
Tutorial: Here, I'll teach you what the errors in Excel mean. There are many errors that you can...
Macro: Convert a numeric dollar amount into its text equivalent. This UDF (user defined function)...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)