Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
Tuesday, August 27, 2024
Webcast or Webinar, Online
10:00AM - 12:00PM (opens at 9:30 AM) 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
Don't have a CPE PowerPass? Click
here to find out more about the CPE PowerPass program.
Course Type: Webcast
Course Code: 24/SUEXLU11
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