Using VLOOKUP, MATCH, and INDEX

December
10
2026 (Thursday)
Time 08:00 AM PST | 11:00 AM EST
Duration: 60 Minutes
18 Days Left To REGISTER
Id: 214295
Instructor
Allen Evitts 
Looking for customized training for your team? Please contact our Customer Support Team (support@masterlearning.com) to discuss your requirements.
Live
Recorded
Live + Recorded

Overview

This practical webinar teaches attendees to build reliable lookup formulas in Microsoft 365 Excel for Windows. The F.I.N.D. method (Find what, In which table, Number of the return column, Decide exact or approximate) breaks VLOOKUP into four clear decisions. Attendees then learn MATCH and INDEX separately before combining them into the more flexible INDEX/MATCH pattern. The session closes with error handling, troubleshooting #N/A, and a brief look at XLOOKUP. A practice workbook with sample data is provided for following along.

Why you should Attend

A lookup formula that returns the wrong value doesn't show an error. It shows a believable number. If you've ever copied a VLOOKUP from a colleague, watched it break after someone inserted a column, or struggled with a sheet full of #N/A errors, this session is for you. You'll learn how each function works, when to use which, and how to build lookups you can trust.

Areas Covered in the Session

  • The anatomy of VLOOKUP, explained through the F.I.N.D. method
  • Exact vs. approximate match: why the default setting causes silent errors, and when approximate match is the right choice
  • VLOOKUP's limits: no left lookups, and hard-coded column numbers that break when columns are inserted
  • MATCH: finding the position of a value in a list
  • INDEX: returning the value at a given row and column position
  • Combining INDEX and MATCH for left lookups, sturdy formulas, and two-way lookups
  • Handling errors with IFERROR and IFNA, and troubleshooting #N/A (extra spaces, numbers stored as text)
  • What comes next: a brief introduction to XLOOKUP

Who Will Benefit

  • Financial, Business, and Data Analysts
  • Accountants, Controllers, and Bookkeepers
  • Operations and Supply Chain Professionals
  • HR and Payroll Professionals who reconcile lists
  • Project Managers who combine data from multiple sources
  • Excel users comfortable with basic formulas who want to go further

Speaker Profile

Allen Evitts is a seasoned project management professional with extensive experience in the field. With a career span of over two decades, Allen has successfully led numerous projects across various industries, including technology, healthcare, and construction. Allen's expertise lies in both traditional and Agile project management methodologies, making them a versatile and knowledgeable instructor. Allen has a proven track record of delivering projects on time, within budget, and to the satisfaction of stakeholders. Their ability to organize, communicate, and lead teams has earned them recognition as a top project management consultant. Allen's approach to project management is rooted in practical, real-world experience, ensuring that participants in their webinars gain valuable insights and actionable skills.

In addition to their professional experience, Allen is a certified Project Management Professional (PMP) and holds certifications in Agile methodologies, including Scrum Master, and in Cybersecurity. Allen is also an active member of the Project Management Institute (PMI).

Allen's passion for teaching and mentoring has led them to develop and deliver comprehensive training programs that empower project professionals to excel in their roles. Their engaging and interactive teaching style ensures that participants not only learn the essential skills but also feel confident in applying them to their projects. Join Allen Evitts in the webinar "Organize, Communicate, Lead: Essential Skills for Project Professionals" to enhance your project management skills and lead your projects to success!
Access Recorded Version
One Attendee / Group Attendees

Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)