Excel Lookup Functions

Susanne Manz Instructor:
Susanne Manz 
60 Minutes
Webinar ID: 501332

More Trainings by this Expert

Price Details
Recorded Webinar
$199 One Attendee
$399 Corporate Recorded

Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)


Excel’s 500+ functions represent a potent set of power tools that simplifies many different kinds of formulas and gives 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 on 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

Speaker Profile
Susanne Manz ,MBA, MBB, RAC, CQA is an accomplished leader in the medical device industry with emphasis on quality, compliance, and six sigma. She has an extensive background in quality and compliance for medical devices from new product development, to operations, to post-market activities. While at GE, J&J, and Medtronic, Susanne worked in various world-wide roles including Executive Business Consultant, WW Director of Quality Engineering and, Design Quality, and Director of Corporate Compliance. Susanne has a BS in Biomedical Engineering and an MBA from the University of NM.

She earned her Black Belt and Master Black Belt certifications while at Johnson and Johnson. Susanne also holds Regulatory Affairs Certification (RAC) from RAPS and Certified Quality Auditor (CQA) certification from the American Society for Quality. Susanne has now established a consulting business with a mission to provide services to help medical device companies achieve world-class quality and compliance.

You Recently Viewed

Subscribe to our Newsletter

Subscribe for Compliance Alerts Research Reports Absolutely Free