Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)
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.

6/29/2017
When: Thursday, June 29 , 2017
8:00 am - 10:00 am
Where: Webcast/Webinar
Surgent
EXLU-2017-01-WEBNR-180-01
United States
Contact: April Deneault
801-466-8022


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.

 

  • Using lookup functions as an alternative to direct cell references
  • Understand the limitations of the VLOOKUP function
  • Discover ways to move beyond these limitations
  • 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
Accounting professionals using Excel 2007, Excel 2010, or Excel 2013 for Windows

Membership Management Software Powered by YourMembership  ::  Legal