Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations

Monday, February 10, 2025
Webcast or Webinar, Online
11:00AM - 1:00 PM (opens at 10:30AM) EST
2Credits
Technical Business

Registration is Open

Members
$99.00 Regular Price
Non-Members
$129.00 Regular Price

CPE PowerPass Users

Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.
$40.00 Members / $56.00 Non-Members
Course Type: Webcast
Course Code: 24/SUEXLU15
Level: Basic
Vendor: Surgent
Field of Study: Computer Software and Applications

Overview:

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.

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

Major Topics:

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

Major Topics:

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

Designed For:

Accounting professionals using Excel for Windows

Prerequisites:

Basic knowledge of Excel for Windows