Webinar

Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations

---

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Major subjects

• Using lookup functions as an alternative to direct cell references
• Understand the limitations of the VLOOKUP function
• Discover ways to move beyond these limitations

Learning objectives

• Recognize when and why a lookup function is better than a direct cell reference
• Use three of Excel's many lookup functions
• Gain comfort with the arguments of the functions presented

Who should take this program?

• Accounting professionals using Excel for Windows

Pricing

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

---

Related programs

July 20, 2026 | K2's Dynamic Arrays in Excel | Webinar

July 22, 2026 | K2's Excel's Best New Features | Webinar

July 22, 2026 | K2's Eight Awesome PivotTable Features | Webinar

July 22, 2026 | Microsoft Excel: Moving Beyond the Basics | Webinar

July 22, 2026 | Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation | Webinar

---

Related products

Advanced Excel for Staff: Build Reports and Analyze Data | Self-Study (On-Demand)

Complete Guide to Analyze Data With Excel PivotTables | Self-Study (On-Demand)

Finding Errors in Excel Spreadsheets | Self-Study (On-Demand)

Mastering the Excel Lookup Functions | Self-Study (On-Demand)

Shortcuts That Excel Users Love | Self-Study (On-Demand)

---