Main Profile

At A Glance

Excel Lookup & Search Tip 8 - Vlookup with Lookup Values that Have Extra Values in the Cell in Excel

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to use the VLOOKUP() function with lookup values that have prefixes on them. This means that you will be able to search a data base for parts of the characters or text within a cell. This tutorial is very useful for people who do not have control over source data and or often import external data such as from CSV files and need to use only part of the imported values to search a data table. You will learn how to use the LEFT() and RIGHT() text manipulation functions in Excel in order to achieve the desired outcome. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Length: 05:25

Contact

Questions about Excel Lookup & Search Tip 8 - Vlookup with Lookup Values that Have Extra Values in the Cell in Excel

Want more info about Excel Lookup & Search Tip 8 - Vlookup with Lookup Values that Have Extra Values in the Cell in Excel? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question