VLOOKUP, HLOOKUP, and 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 time, work smarter, and boost your efficiency and productivity.
Course Objectives:
To gain a practical “hands-on” understanding of key Lookup functions in MS Excel.
Areas Covered:
• Vlookup - Range Lookup Table with Absolute References
• True and False - The 4th Parameter Demystified
• Vlookup Function - Exact Match Lookup Table with Named Range
• Tables - The Key to Future-Proofing Vlookup
• Using the Insert Function Wizard with Vlookup
• Vlookup Link to External Data using Insert Function
• Vlookup – Incorporating other Excel Functions
• Hlookup - Range Lookup Table with Absolute References
• Hlookup Function - Exact Match Lookup Table with Named Range
• Formula Auditing
• How to suppress #NA error messages
• NEW: The XLOOKUP Function
Why Should You Attend
• Understand the latest powerful and most relevant MS Office functions available
• Work smarter, faster, and more effectively
• Boost profit, efficiency, and productivity
• Improve job satisfaction, team performance, and professionalism
• Gain a strong competitive advantage at the peer and business level
• Achieve more in less time with higher quality results.
• Strengthen your resume and justification for increased salary
Course Outline:
• How to look up a value in list one and pick up a related value from list two
• How to avoid lookup formulas displaying an error when it can't find a match
• What's HLOOKUP and what’s XLOOKUP?
• These are just a few questions 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 key lookup functions that are built into Excel
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
Anyone seeking to significantly boost profits, competitive advantage, productivity, job satisfaction, and effective use of their technology.
Excel Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP Made Easy
Get Instant Access 60 Minutes View Program |
Advanced Excel Functions: Lookups, Logic, and More
Get Instant Access 90 Minutes View Program |
INTERMEDIATE FUNCTIONS, LOOKUPS & LINKING IN MS EXCEL
Get Instant Access 90 Minutes View Program |
Microsoft Excel®: Lookup Functions and 3-D Excel file
Get Instant Access 90 Minutes View Program |
Lookup Functions, Formula Tracing & Named Ranges in Excel
Get Instant Access 90 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry