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