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.

5/14/2015
When: 5/14/2015
8:00 AM - 10:00 AM
Where: Webcast/Webinar
Presenter: Jeff Lenning
Contact: April Deneault
801-834-6634


Online registration is closed.
« 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 presentedts


 

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: Info Tech

Level: Basic

CPE Credit: 2 Hours

Acronym: EXLU

 

Registration Fees:

$89

 


Membership Management Software Powered by YourMembership.com®  ::  Legal