CPCC login required. Recommended: DPT 8015 or equivalent knowledge. VLOOKUP is one of Excel's most useful functions, and it's also one of the least understood. In this workshop you will learn how VLOOKUP works with database tables, or more simply, lists of things in an Excel worksheet. Use VLOOKUP to match two lists and quickly find the data you want which will make working with data easy.