Print Page   |   Contact Us   |   Sign In   |   Join
Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)
View Registrations Tell a Friend About This EventTell a Friend
 

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.

10/29/2015
When: 10/29/2015
8:00 AM - 10:00 AM
Presenter: Jeff Lenning

« Go to Upcoming Event List  

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 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

 

Designed for: Accounting professionals using Excel 2007, Excel 2010, or Excel 2013 for Windows

 

Prerequisite: Basic knowledge of Excel for Windows

 

Advanced Prep: None

 

Speaker: Jeff Lenning

 

Vendor: Surgent McCoy

 

Field of Study: Spec. Knowledge (2)

 

Level: Basic

 

CPE Credit: 2 Hours

 

Acronym: EXLU

 

Registration Fees: $89.00

 

 

Register Here

 

 

Membership Management Software Powered by YourMembership  ::  Legal