Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)
Date/Time
11/11/2024
9:00 AM - 11:00 AM Central
Course Registration
Member: $99.00
Non-Member: $119.00
Credits
2 Credits
Event Type(s)
Webinars
Event Description
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

Presenters:
Jeff Lenning

Field of Study:
Computer Software & Applications (2)

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
Location
Webinar
Outlook/vCalendar/Google
Click on the icon next to the date(s) to add to your calendar:
11/11/2024   Outlook Calendar Apple Calendar Google Calendar


return to North Dakota CPA Society