"How do I look up a value in list ONE and pick up a related value from list TWO"
"How do I avoid my lookup formula displaying an ugly error when it can't find a match?" "I've heard of VLOOKUP but what's HLOOKUP and what’s XLOOKUP?"
These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering the various lookup functions that are built into Excel.
WHY SHOULD YOU ATTEND?
VLOOKUP, HLOOKUP, XLOOKUP are some of the most well-known (and most useful) formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks, save a ton of time and minimize data entry errors.
LEARNING OBJECTIVES
- How to construct and use the VLOOKUP function
- TRUE and FALSE - the 4th parameter demystified
- Tables - the key to future-proofing VLOOKUP
- How to construct and use the HLOOKUP function
- How to avoid #NA
- NEW: The XLOOKUP Function
WHO WILL BENEFIT?
- This training is categorized as intermediate-to-advanced. It is aimed at users who want to learn about the Lookup functions in Excel
- Although the training will be delivered using the latest version of Excel, this training is relevant for users of Excel 2010 and above
VLOOKUP, HLOOKUP, XLOOKUP are some of the most well-known (and most useful) formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks, save a ton of time and minimize data entry errors.
- How to construct and use the VLOOKUP function
- TRUE and FALSE - the 4th parameter demystified
- Tables - the key to future-proofing VLOOKUP
- How to construct and use the HLOOKUP function
- How to avoid #NA
- NEW: The XLOOKUP Function
- This training is categorized as intermediate-to-advanced. It is aimed at users who want to learn about the Lookup functions in Excel
- Although the training will be delivered using the latest version of Excel, this training is relevant for users of Excel 2010 and above
Speaker Profile

Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with Mac OSX and Mac-related software since 2006; however, his passion is for all-things-Excel and in 2012 he founded the website theexceltrainer.co.ukMike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In …
Upcoming Webinars

Contractor vs Employee: How to Tell the Difference and What…

Imposter Syndrome: How to Define, Understand & Shift Your E…

FDA current recommendations related to timely initiation of…


Impact Assessments For Supplier Change Notices

Implicit Bias: Becoming Aware of Your Inner Storyteller

Complying with the NEW I-9 and E-Verify Regulations - The I…

The Federal Anti-Kickback Statute & Stark Law: What Physici…

Building an Effective Injury Management Process

Fatal Errors Employers Make When Updating Employee Handbook…

Understanding the Changes Coming to NCCI's Experience Mod i…

From Awareness to Action: Going Beyond the Law in Preventin…

Onboarding is NOT Orientation - How to Improve the New Empl…


From Awareness to Action: Going Beyond the Law in Preventin…


FDA Compliance and Clinical Trial Computer System Validation

5 Proven Ways To Engage & Retain Your Team Even During The …


Customer Relationship Management: Strategic Methods to Mana…

Navigating New Paths: Unveiling Your Unique Abilities for a…

Form 1099 Update 2023: Latest Forms, Rules and Reporting Re…

Strategic Interviewing & Selection: Getting the Right Talen…



Project Management for Non-Project Managers - How to Effect…

Implementing a Robust Change Control Program - Key Elements…

Amazing (!) AI Tools For Building Your Business



Excel - Unleashing the Full Potential of New Functions (Exc…

How to Conduct Annual Product Reviews to Achieve GMP Compli…



What Business Leaders Need to Know About Cybersecurity Prep…

Responding to EEOC Discrimination Charges-What's Your Busin…

Harassment, Bullying, Gossip, Confrontational and Disruptiv…