Excel Forum
Excel VBA Course
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.)

View Course

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

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.
   Topics Covered
Use the VLOOKUP() function on a database that contains prefixes before the lookup values.
VLOOKUP() function in Excel.
Complex data queries in Excel.
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.