Self-Study

Surgent's Mastering the Excel Lookup Functions

---

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs.

Major subjects

• A review of the various lookup functions, beyond VLOOKUP
• Which lookup works best for your situation?
• How to apply the many lookup functions
• Advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively
• An in-depth review of the following functions: VLOOKUP/HLOOKUP, XLOOKUP, MATCH / INDEX, XMATCH, INDIRECT, FILTER, SORT/SORTBY, UNIQUE
• An overview of some newer functions

Learning objectives

• Identify which lookup function works for your needs
• Distinguish between the many lookup functions
• Recall how to effectively utilize Excel's lookup functions

Who should take this program?

• Any Excel user that wants to learn how to use the LOOKUP functions

Pricing

Our records indicate you are a nonmember. If you register, you will be charged $109.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.

---

Related programs

Dec. 9, 2025 | K2's Excel Essentials for Staff Accountants | Webinar

Dec. 9, 2025 | Surgent's Excel Shortcuts for Accountants | Webinar

Dec. 9, 2025 | Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check | Webinar

Dec. 9, 2025 | Excel for Accounting Professionals Session 7: Data-Driven Workbooks and Concatenation | Webinar

Dec. 9, 2025 | Excelling at Excel: Tips, Tricks and Updates | Webinar

---

Related products

Advanced Excel: Hidden Secrets and Gems | Self-Study (On-Demand)

Excel: Advanced Defined Names & Excel Tables | Self-Study (On-Demand)

Excel: Advanced Financial and Statistical Calculations | Self-Study (On-Demand)

Excel: Advanced Formatting to Improve Your Spreadsheets | Self-Study (On-Demand)

Excel: Advanced Spreadsheet Troubleshooting Techniques | Self-Study (On-Demand)

---