5 Bite-Size Vlookup Tricks for Excel

Add to Favorites
Author: | Edits: don

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


Downloadable Files: Excel File

Similar Content on TeachExcel
5 Simple Printing Tricks for Excel
Tutorial: [placeholder for files]...
Variables in Macros VBA for Excel - Practical Guide
Tutorial: This is a practical guide to using Variables in Macros and VBA for Excel. I will tell you ...
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can...
Convert Numeric Dollar Values into Text in Excel - UDF
Macro: Convert a numeric dollar amount into its text equivalent. This UDF (user defined function)...
Change the Default Number of Worksheets Created in a New Excel Workbook
Tutorial: Learn how to change the number of worksheets that are in new Excel workbooks. Excel work...