VLookup is your friend, I promise

April
21
2026 (Tuesday)
Time 10:00 AM PDT | 01:00 PM EDT
Duration: 60 Minutes
47 Days Left To REGISTER
Id: 212044
Instructor
Kelly Ladd 
Live
Recorded
Live + Recorded

Overview

Master VLookup to merge datasets, find data, and more!

Why you should Attend

Have you ever attempted to use the VLookup function and just couldn’t quite get it to work? Or maybe it worked sometimes, but mysteriously not others. And what is a range lookup anyway? 

This industry-standard Excel function is simple in concept, but there are things about VLookup than can trip you up if you aren’t aware of how they work. I’ll show you what you need to know to master this useful tool to merge data, compare lists, create dynamic data retrieval, and more.

VLookup will be your friend, and you’ll be the office hero!

Areas Covered in the Session

  • Understanding the problem VLookup solves
  • What would you do without VLookup?
  • Understanding the arguments of VLookup
  • When and why you need to use Range Lookup
  • What you need to do to copy VLookup
  • HLookup

Who Will Benefit

  • Administrative assistant
  • Human resources (HR) administrator
  • Market researcher
  • Sales Manager
  • Medical Administration
  • Rising College Students
  • Fleet Manager
  • Cost Estimator
  • Project Manager
  • Rising High School Grads

Speaker Profile

Kelly Ladd is a certified MOS Excel Expert with over a decade of experience tutoring, consulting, and executing Excel worksheet skills. She specializes in teaching mathematical, logical, and financial functions as well as more advanced functions and features such as VLookup, PivotTables, and What-if Analysis. Kelly’s students respond to her easy-going approachable style that breaks down complex concepts into understandable and useful information. Kelly delights in “ahhhh” moments when students connect with an idea that will improve their Excel know-how. “There is so much that Excel can do. You already have the program. All you need to do is learn how to harness the power that’s there!”
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)