Excel Lookup Functions
Excel’s 500+ functions represent a potent set of power tools that simplifies many different kinds of formulas and give you a huge number of computational possibilities.
Some of the more important Excel functions are those categorized as Lookup and Reference functions. In addition to the widely used VLOOKUP function (and its companion HLOOKUP), significant functions like MATCH, INDEX, SWITCH, and CHOOSE are also needed at different times to retrieve data from lists and tables. Two newer functions - XLOOKUP and XMATCH - provide powerful new capabilities and ease of use and can ultimately replace the use of VLOOKUP, HLOOKUP, and MATCH functions. Newer lookup functions include CHOOSEROWS, CHOOSECOLS, TAKE, and DROP - additional tools to get to the data you need quickly and efficiently. This session presents in-depth coverage of all these functions, as well as providing attendees with the perspective they need to understand the scope and depth of these important Excel features.
Why should you Attend:
Among Excel’s 500+ functions is a category - Lookup & Reference - that contains some of the most important and widely used of all Excel functions. In fact, based on Microsoft analysis of Excel usage, the VLOOKUP function is the third most frequently used function (after SUM and AVERAGE) in Excel.
This webinar focuses on not only VLOOKUP, but also companion functions - HLOOKUP, INDEX, and MATCH - that have long been available in Excel, but also the newer functions, like XLOOKUP, which will ultimately replace both VLOOKUP and HLOOKUP and the XMATCH function, a replacement for the widely used MATCH function.
In addition to providing examples of the more significant lookup functions (there are 26 of them), this webinar gives you insight into Excel’s new calculation engine that can provide multiple answers from a single formula that spills results into adjacent cells.
All examples will be presented within the context of Excel worksheets based on real-life examples encountered over the past 25 years of Excel consulting and teaching experience.
Numerous productivity tips, shortcuts, and accelerator tools will be presented throughout the session.
Areas Covered in the Session:
- Learn how to look up information in tables and reconcile different lists using the VLOOKUP function, and its companion, HLOOKUP
- Learn how to use the new XLOOKUP function -easier to use than VLOOKUP and HLOOKUP, and greatly expanding on the capability of those functions
- Learn how to use the MATCH and INDEX functions for matching and extracting data from tables and lists
- Learn how to use the new XMATCH function that replaces MATCH and expands its functionality
- Learn how to use the CHOOSE and SWITCH functions to match data with lists embedded within the functions
Who Will Benefit:
- Any Excel user who needs to become familiar with vital Excel functions increasingly needed by most Excel users
Accomplishments: Dennis has authored and presented nearly 700 webinars on various Excel topics in the past 11 years. He has also produced numerous Excel courses on video, CD, and DVD and has taught more than 500 seminars and over 5,000 classes on the subject. Dennis is the author/presenter of over 200 hours of online Excel courses available at LinkedIn Learning. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field.
He's taught for numerous corporations, government agencies and colleges and universities, including: Northrop-Grumman, Raytheon, Levi Strauss, Chevron, BP, IBM, Apple, Driscoll's, Amgen, AT&T, Qwest, Anheuser-Busch, Starz-Encore, University of Phoenix, University of Colorado, US Department of Labor, Bureau of Land Management, Great-West Life Insurance, Texaco, Lexmark, Time-Warner, Environmental Protection Agency, National Seminars, and the Cities of Denver, Boulder, Longmont, and Westminster, CO.