Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it

Page Navigation

Main Profile

At A Glance

Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to use the VLOOKUP function in Excel to search a database or table array which contains lookup values that have prefixes. This allows you to only have to enter part of the lookup value for the vlookup function and still have it work. This problem might arise if you search employee id numbers but the database includes a division prefix before the id numbers. This tutorial essentially combines text with formulas in order to streamline the lookup process in Excel. For Excel consulting 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:
04:38

Contact

Questions about Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it

Want more info about Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it?
Get free advice from education experts and Noodle community members.