Mastering Lookup Functions Error Suppression And Xlookup In Excel
  • CODE : ROMK-0061
  • Duration : 90 Minutes
  • Level : Intermediate
  • Add To Calendar
  • Refer a Friend

Ray’s professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.

With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.

Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.

Having trained over 25,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.



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.

Learning 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

Who Should Attend

Anyone seeking to significantly boost profits, competitive advantage, productivity, job satisfaction, and effective use of their technology.

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

Topic Background

  • 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
  • $160.00



Webinar Variants


contact us for your queries :

713-401-9995

support at grceducators.com



Secure Payment