Lookup formulas such as VLOOKUP allow you to return data from other locations in your spreadsheets without linking to individual worksheet cells. However, VLOOKUP can't always return the data that you need.
In this webinar, Excel expert Dennis Taylor explores the nuances and limitations of VLOOKUP, helps you expand your use of this function, and then presents you with a handful of alternatives.
Years of Experience: 25+ years
Areas of Expertise: Microsoft Excel
Dennis Taylor is an Excel expert. He has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990s. He’s traveled the United States and Canada giving seminars to help his students unlock the full potential of Excel. Dennis has a unique ability to describe, decode, and demystify the myriad functions of Excel for individuals and businesses. He’s taught hundreds of workshops and authored numerous tomes on this program.
Accomplishments: Dennis’s 25-year track record of Excel exploits is nearly overwhelming in scope and volume. He has penned and presented more than 600 webinars on various Excel topics in the past nine years. Dennis has also produced numerous Excel courses on video, CD, and DVD. As if this wasn’t enough contribution to Excel education, he’s taught more than 500 seminars and over 5,000 workshops on the subject. Dennis partnered with Lynda.com (now part of LinkedIn) to make his training even more widely available—he’s posted nearly 200 hours (over 50 courses) of easy-to-understand Excel explanations there. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field. Whether you’d prefer to read, watch, or listen, he can share his expertise with you.View all trainings by this speaker