Transcend VLOOKUP in Microsoft Excel

Learn valuable insights and strategies from industry experts.

  • Expert-led Training
  • Industry Best Practices
  • Practical Implementation
  • Real-world Scenarios
Craig Brody

Speaker: Craig Brody

Download Brochure Set Reminder
Software Webinar Image
Date
14 July, 2026 (Tuesday)
Time
12:00 PM PDT | 03:00 PM EDT
Duration
60 Minutes

Overview


Go beyond Excel's Vlookup function to overcome its limitations. The focus in this course will be on using the next generation lookup function called Xlookup. See how you can use it to do lookups in any direction, do 2-way lookups, and embed error messages within it. Includes comparing Vlookup with Xlookup functions side by side. Also covers the Index, Match functions and the Defined Names command.

Area Covered

  • Review of Vlookup 
  • See how the XLOOKUP function overcomes Vlookup's limitations in a side by side comparision
  • See how XLOOKUp can lookup data in any direction
  • Use XLOOKUP for 2 way lookups and built-in error messaging
  • Apply XLOOKUP in exact and approximate match examples
  • Index and Match functions 
  • Defined Names command

Why Should You Attend

Go beyond Excel's Vlookup function to overcome its limitations. The focus in this course will be on using the next generation lookup function called Xlookup. See how you can use it to do lookups in any direction, do 2-way lookups, and embed error messages within it. Includes comparing Vlookup with Xlookup functions side by side. Also covers the Index, Match functions and the Defined Names command.

Who Will Benefit?

  • Managers
  • Business Professionals
  • Administrative Personnel
  • Legal Professionals

Speaker

Craig Brody operates Craig Brody, LLC, a business that provides software training and consulting services. Craig has trained numerous employees, managers, executives, and students in various application software, including Microsoft 365 Copilot and Adobe Acrobat Pro. He conducts and facilitates in-person, online, and recorded training workshops for professionals in accounting, business, management, and law. Craig also conducts workshops, classes, and consulting services for the University of Pennsylvania's Wharton Business School, Penn Carey Law School, law firms, accounting associations, and accreditation providers. His services include spreadsheet analysis, design and troubleshooting, software programming, consulting, published course guides, recorded courseware videos, and other reference materials.

Upcoming Webinars

View All Webinars