BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
PRODID://NDCP//488237
BEGIN:VEVENT
DTSTAMP:20260429T170145
VTIMEZONE:America/Chicago
DTSTART:20260612T140000Z
DTEND:20260612T160000Z
UID:488237
SUMMARY:Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)
LOCATION:Webinar
DESCRIPTION:Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)\n\n06/12/26 09:00 AM CST\n - 06/12/26 11:00 AM CST\Description:\nHow 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 LenningField 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:\nWebinar\n\n,
X-ALT-DESC;FMTTYPE=text/html:Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (EXLU)<br /><br />06/12/26 09:00 AM CST - 06/12/26 11:00 AM CST<br />Description:<br />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.<br><br><b>Objectives:</b><br><ul>
    <li> Recognize when and why a lookup function is better than a direct cell reference </li>
    <li> Use three of Excel's many lookup functions </li>
    <li> Gain comfort with the arguments of the functions presented </li>
</ul><br><b>Presenters:</b><br>Jeff Lenning<br><br><b>Field of Study:</b><br>Computer Software & Applications (2)<br><br><b>Major Topics:</b><br><ul>
    <li> Using lookup functions as an alternative to direct cell references </li>
    <li> Understand the limitations of the VLOOKUP function </li>
    <li> Discover ways to move beyond these limitations </li>
</ul><br />Location:<br />Webinar<br /><br />,  
PRIORITY:3
TRANSP:TRANSPARENT
BEGIN:VALARM
TRIGGER:-PT5M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR